Open form Question

[loneranger27]

Hi,

I have a form where we enter information about a car.
and the user selects the type of car from a combo box.

What I want to do is that if the combo says dodge truck then the truck form opens if it says dodge car then the car form opens and so on.
I tried if then statements and did not have goodluck
if [combo22] = "dodge truck" then docmd.Openform ("truck&quot
the form opens and I get an error that access cannot find the field forms referred to in the expression. The truck form is a linked form.

Any help would be appreciated.
Thanks

 

[WayneRyan]

lone,

A nice way to do this is to have a combo box (srchCombo)
that displays keys from some table. In the AfterUpdate
event of the combo, do:

DoCmd.OpenForm "VehicleForm",,,"[EditVehicles]"

This will open the form and display all vehicles of a
certain type.

In you situation, use the AfterUpdate event:

If InStr(1, Me.srchCombo, "truck") > 0 Then
   DoCmd.OpenForm "truck"
ElseIf InStr(1, Me.srchCombo, "van") > 0 Then
   DoCmd.OpenForm "van"
End If

You really shouldn't need to have a different form for
each type of vehicle. It will mean more work for you
in the long run.

Wayne