You don't need FindFirst at all:
docmd.openform "frmCabs", WhereCondition:="AANo=" & Me.AANo
Form.Recordset.FindFirst
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 54%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECP%3C/text%3E%3C/svg%3E)
Chris Parkin
1
Reputation point
Hi
I have a report with a simple DblClick event on a field to open a form at the record I have just double clicked...
Using the same principle, I want to put a command button on a sales form which when clicked, opens the product detail form related to that sale, but I'm missing something that is stopping it working...
I'm thinking that it may be because the succesful find.first in the first example is based upon the field in the report that I am double clicking, whereas the new one I am trying to work out is just a simple command button.
Your help would be appreciated.
Many thanks
5 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 41%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
Tom van Stiphout 1,696 Reputation points MVP2021-01-29T14:03:26.74+00:00 -
Chris Parkin 1 Reputation point
2021-01-29T14:20:29.563+00:00 Thanks for that, but unfortunately that doesn't work. Does it make a difference that the AANo field I am referencing is in a tab on the main form.
'View Cab Record' is the command button I'm trying to code and you'll see the AANo field over to the right.
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 47%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
LEllefson 76 Reputation points2021-01-29T17:27:31.597+00:00 Try:
"AANo=" & Me.Cab.AANo because Me refers to frmCabs which contains Cab as a tab control.
-
Chris Parkin 1 Reputation point
2021-02-01T09:42:56.163+00:00 Thanks Larry. That doesn't work but then that may be because the previous screen image is part of the main sales record form called 'frmVehicleSales'. It is this form that has the Cab tab on it. Clicking the View Cab Record button needs to open the form 'frmCabs' and find the AANo record referenced in the sales record form.
Sign in to comment -
-
LEllefson 76 Reputation points
2021-02-01T14:13:24.283+00:00 Then try:
"AANo=Forms![frmVehicleSales]![frmCabs]![Cab]![AANo]"
-
Chris Parkin 1 Reputation point
2021-02-01T15:19:21.397+00:00 Hi Larry. You're suggestion result in this:
I've continued my research but cannot get the right results. Maybe I'm just not using the best search terms.
Sign in to comment -
-
LEllefson 76 Reputation points
2021-02-01T16:28:03.257+00:00 Oh sorry, AANo might need to be bracketed like:
"[AANo] = Forms![frmVehicleSales]![frmCabs]![Cab]![AANo]"
-
Chris Parkin 1 Reputation point
2021-02-01T16:58:38.53+00:00 Sorry, same syntax error again. I don't want to give up this as that is defeatist, but it's starting to break me.
Sign in to comment -
-
LEllefson 76 Reputation points
2021-02-01T17:32:30.187+00:00 Going back and looking at your original question, it appears you are trying to open frmCabs again for a second time using criteria, but it is already open as a SubForm of frmVehiclesSales. You can't open it again so you need to create a different form.
- Open your navigation pane
- Copy frmCabs.
- Rename the copied form frmViewCab
- Try DoCmd.OpenForm "frmViewCab", acNormal, , "[AANo] = Forms![frmVehicleSales]![frmCabs]![Cab]![AANo]" on your command button
This should open frmViewCab in a separate window using the criteria you want.
-
Tom van Stiphout 1,696 Reputation points MVP
2021-02-01T23:32:04.123+00:00 Larry, you may want to try before you make a statement. The tab control syntax was wrong, and opening a subform as a mainform is wrong as well.
Sign in to comment