Problem getting the correct record 1

[vias]

I have a combo box and a button next to it
called 'GO'. The combo box gets a list of names
from a table. The 'GO' button is to display
a form attached to a table TabContact

When I click on 'GO' I want the appropriate record
from the table TabContact to be displayed depending
on the name I choose from the combo box.

The problem is whatever I select from the combo and
click on 'Go', it always displays the first record.

Can anybody help.

Thanks.
Vias

 

[lupins46]

Why not put the combo box onto the Tabcontact form and let the combo-box wizard do this for you.

 

[PHV]

Take a look at OpenArgs

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[RoyVidar]

Use the good old create button wizard to open a form. Use the opgtion "Open the form and find specific data to display". Follow the wizard to select which control to bind to which field in the next form. Let this button become your new "go" button. Perhaps add some test for Null/no selection in the combo?

Roy-Vidar

 

[vias]

Roy-Vidar,

Thanks for your help....it works now..

Vias