new with forms

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

Guest

hello there
one question pls, there is one query comes from 2 simple tables.
i want one form based on this query, so i can moved from record to record
using a combo box and not that record counter down left...changing one value
from the combo to get all the appropriate values from that record to the text
box.
i tried that using the wizards and all i done is change only the specific
field (the combo box field).
i have no idea how i can do that so any help is important
thanks
 
vassilis said:
hello there
one question pls, there is one query comes from 2 simple tables.
i want one form based on this query, so i can moved from record to
record using a combo box and not that record counter down
left...changing one value from the combo to get all the appropriate
values from that record to the text box.
i tried that using the wizards and all i done is change only the
specific field (the combo box field).
i have no idea how i can do that so any help is important
thanks
Click to expand...

When you used the wizard, did you tell it that you wanted the option to
"Find a record on my form"? That's the one you should have chosen. It
sounds like you have a simple combo box that is bound to a field in your
query. That's not what you want. You need an unbound combo box (blank
ControlSource) with some code behind its AfterUpdate event to move to
the matching record. The wizard should build this for you if you choose
the "Find a record ..." option.
 
Back
Top