Switchboards

[Guest]

I have a switchboard with links to specific tables to display all of the records contained within it. I would like to create a command to go straight to a specific customer detail. For example, I have a table called customer details, I would like to click on a button from the Swichboard and be prompted to enter the customer's surname, this will then take me straight to that record.

Help please..................

 

[Steve Schapel]

Amanda,

You can put an unbound textbox, or preferably a combobox, on the
switchboard form, where you can select the customer (if you use a
combobox, the actual value of the combobox will be the Customer ID
rather than the customer surname, even though you can set up the
combobox so that the name is what is displayed). Then, you can put code
like this on the Click event of the command button...
DoCmd.OpenForm "Customer Details", , , "[Customer ID]=" &
Me.NameOfYourCombobox
This will show the record for the selected customer.