Form Field Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Need assistance with query behavior. I have a field (field 1) on my form
that is based on a query to get a location. I want another field (field 2)
on the same form to return the location information based on what I select in
the first field and enter the ID from that record into the table. The
problem I'm having is that when I go to that page (form) it only generates a
query on what is in field 1. When I change field 1 the information in field
2 doesn't change. Any recommendations?
 
Need assistance with query behavior. I have a field (field 1) on my form
that is based on a query to get a location. I want another field (field 2)
on the same form to return the location information based on what I select in
the first field and enter the ID from that record into the table. The
problem I'm having is that when I go to that page (form) it only generates a
query on what is in field 1. When I change field 1 the information in field
2 doesn't change. Any recommendations?
Click to expand...

why not use a combobox with two columns. Include the field you want
to display as a hidden column (width=0) then you can refer to it in
the second unbound textbox.

=Me.Controls("MyCombo").Columns(1)
 
Back
Top