sycronize combo box and form selection

[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

 

[Van T. Dinh]

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)

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.

 

[Guest]

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

When I select a persons name from my combo box i dont get the record t

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

 

[Van T. Dinh]

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.