How to set Do.Cmd.OpenForm and then set a combobox value

[Mike79]

Hi,

I'm pretty new to access, so this may be quite easy but I just can't get it. Situation as follows.

I have a split form for Inventory (InventoryF) that has a combo box that allows me to select a Trailer number, then the contents of the trailer are displayed.
I have a second form for Trailer/Vehicle information (VehicleF) that shows license numbers, etc.


I would like to use an event procedure on a double click event (or if there is a better suggestion than double click, I am all ears), in the VehicleF that will open the InventoryF and set the combobox to whatever I double clicked on. (i.e. double click on Trailer 1 in the VehicleF, and it opens InventoryF to Trailer1).

Just opening the form is real basic (DoCmd.OpenForm "InventoryF"). But setting the combo box, I've failed. I tried:

DoCmd.OpenForm "InventoryF", _
WhereCondition:="cboTrailer=" & Me.TrailerName

(cboTrailer is my combo box on InventoryF, and TrailerName is the corresponding name on VehicleF)

That returns a Syntax Error (3075) saying I have a missing operator. I tried a slew of other things too. Any help is appreciated. Thank you!

[pbaldy]

If the value is text it needs delimiters:

http://www.baldyweb.com/wherecondition.htm

[Mike79]

Thanks Paul. I went in that direction on one of my tries.

DoCmd.OpenForm "InventoryF", , , "cboTrailer = '" & Me.TrailerName & "'"

With this, it errors wanting a value for cboTrailer. I'm concerned I'm coming at this from the wrong angle completely, but I'm learning slowly....

[Minty]

You can't set the value of an combo in that fashion, you would have to pass the value to the form, and process it that way in the forms load event.

However If you want to filter the form by that value then use the field name to do it;

DoCmd.OpenForm "InventoryF", , , "[YourTailerFieldName] = '" & Me.TrailerName & "'"

[pbaldy]

I'll get out of the way.

[Mike79]

Thanks Paul that worked! You've been very helpful. A couple more questions though if you dont mind.

1. The users can open the InventoryF in a secondary way, so I previously had a default setting for FormLoad so that it opened to a Select Trailer generic screen. If I have a default in formload, the code you suggested doesn't work because it takes that default. Is there a work around?
2. Is it possible to also set the combo box? The reason being, is that the users can use secondary boxes for search functions. Those search boxes look to see what trailer is selected in the combo box. If the combobox is null, it doesn't search correctly.

Thanks again.

[Mike79]

Oh shoot, I just realized there are 2 of you responding. Sorry, newb on this forum too. Minty, my last post should have been addressed to you.

Paul, you definitely aren't in the way! If there is a smarter way I'm all ears.