Open form to current record

[rbpd5015]

I have a form in which I have a vehicle section. (Tag, vin, color, make, model). (Called Vehicle form)



I then have a second form which has a drop down of where I select the vehicle based on its vehid (PD5005, PD4002...etc). That form is called Vehicleinfo.

Want I want is a button that when I click it takes me to the make vehicle form listed at top and to the currently selected record.

So if I am on PD870 I want to be able to click the edit vehicle button and jump to the current record of PD870.

I set up the button using the wizrd but it prompts me to enter the vehicle number. I do not want that.

Below is my where condition I got in the query of the button.

"[VehNum]=" & "'" & [IDVeh] & "'"

What would that need to say.

Matt

[dcrake]

Nearly right

"[VehNum]='" & Me.IDVeh & "'"

Or you can do it another way.

On the OnLoad event of the vehicle info form you can enter

 
Me.Filter = "[VehNum]='" & Forms("Vehicle")("IDVeh") & "'"
Me.FilterOn = True

Make sure you are using the correct field names, if they are different from the above example.

David