sycronize combo box and form selection

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

Guest

When I select a persons name from my combo box i dont get the record to match it from the form. When i first click on my selection from combo box then the form just goes to the next record. Can someone please help me.
Thankyou Jenny
 
Use the ComboBox Wizard to create this ComboBox for you. The option you
should select is "Find a record on my form based on the value I selected in
the combo box" (or something similar). After this, you can look at the code
created by the Wizard.

--
HTH
Van T. Dinh
MVP (Access)



angel82 said:
When I select a persons name from my combo box i dont get the record to
Click to expand...
match it from the form. When i first click on my selection from combo box
then the form just goes to the next record. Can someone please help me.
 
Van how do i know which field to set for the link master and the link child

----- Van T. Dinh wrote: ----

Use the ComboBox Wizard to create this ComboBox for you. The option yo
should select is "Find a record on my form based on the value I selected i
the combo box" (or something similar). After this, you can look at the cod
created by the Wizard

--
HT
Van T. Din
MVP (Access



angel82 said:
When I select a persons name from my combo box i dont get the record t
Click to expand...
match it from the form. When i first click on my selection from combo bo
then the form just goes to the next record. Can someone please help me
 
Generally, they are the linking Fields between the 2 Tables involved in the
One-to-Many relationship.

Check Access Help on Subforms and their use.
 
Back
Top