popup dialog box for finding values from a table in a form

[sviggos]

Dear all,

i have this problem that i think that it is quite easy, though i can not find its solution.
PROBLEM
i have a switchboard with command buttons in order to enter into specific forms.
One of the command buttons directs to a form that its fields are based on a table.
what i want to suceed is to go to this form by selecting a specific record (the name of the customer to be precise) from the table.
i have tried to assign to the command button a macro with the openform and GoToControl macros, which is ok, though i need the last step which is to enter the willing record with maybe a popup dialog box. if the FindRecord can do the job, please, guide me.
thank you

 

[DCrake]

When your form first opens it will show the first record in the underlying record source if it is a bound form. If it is an unbound form then no record will be shown.

Depending on the method adopted you can either create a new form with some sort of search criteria to identify the cleint (for bound forms) then use the open arguments of rthe main form to filter to that client. Or have a drop down combo box to select from a list of existing customers then apply the form filter after selection. (Unbound forms)