View Full Version : Command button help (PICS included!!)


fifaheat
12-22-2001, 04:10 AM
Hi,

When i go to create a command button/ form operations/ Open form. I can only select 1 variable. Heres a screenshot of it:

http://www.gturnock.fsnet.co.uk/screen.gif

Im doing a search to find the cars on my database, i want the search engine button to search for more than one field, however it wont let me select more than 1, as seen on the image.

thanx in advance

Jack Cowley
12-22-2001, 08:49 AM
You will have to write your own code. The Wizard will get you started but if you want to filter by more than one item you have to do it yourself. For example:

DoCmd.OpenForm "MyForm", , ,"[Make] = '" & Me.Make & "' And [Model] = '" & Me.Model & "'"