sycronize combo box and form selection

A

angel82

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
 
V

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)



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.
 
A

Angel82

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
 
V

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.
 
Top