Database field in control

Tech-Archive recommends: Fix windows errors by optimizing your registry

All:

Would appreciate some help in filling a textbox with a field from an access database query where the field is part of a table alias. there is two identical tables in the query, but they are distinct from each other by their table alias name

The following variations do not work, no problem doing this in Access using the double square brackets but not in VB.


ComboRunIn.BoundText = rst![RUN_OUT].[R_ID]
ComboRunIn.BoundText = rst![RUN_OUT.R_ID]
ComboRunIn.BoundText = rst!RUN_OUT.R_ID

Thanks in advance
.

Relevant Pages

  • Re: Database field in control
    ... Would appreciate some help in filling a textbox with a field from an access database query where the field is part of a table alias. ...
    (microsoft.public.vb.controls)
  • Re: list box is not populating my table
    ... to prefill with the associated alias. ... Do you have code that would populate the textbox after the combo box is ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • Re: list box is not populating my table
    ... Sydney, Australia ... I would like the textbox ... > to prefill with the associated alias. ...
    (microsoft.public.access.formscoding)
  • Re: FoxPro does not switch between work areas as focus changes between objects.
    ... Set focus to a textbox in the form.Activatedoes not help. ... The form receives focus but when I select different textboxes with the mouse the correct alias is not selected as indicated by the data session window. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: unwanted email
    ... As you can tell I'm pretty computer illiterate ... and it didn't even occur to me to use an alias for this ... >address when posting to newsgroups or filling out ... webpages. ...
    (microsoft.public.windowsxp.security_admin)