Hi all

Can anyone help point me in the right syntax direction for the following
please...

Using a cmdbtn on frmmDirectory, I would like it to open frmmCustomers and
go straight to the record which is current in the unbound control in
frmmDirectory, I tried the following although it did not work.

Private Sub cmdGotoCustDetails_Click()
DoCmd.OpenForm "frmmCustomers", acNormal, , txtCustomerID =
Me.EditCustSelect, , acWindowNormal
End Sub

Appreciate the assist

TIA
Mick

If txtCustomerID is a text field the condition should look like:
DoCmd.OpenForm ... , "txtCustomerID = " & Me.EditCustSelect & "'", ...

Peter

http://access.xps350.com/

Hi Peter

Thx for your assist.

txtCustomerID is a PK NumericField that is set to AutoNumber.

this way have something to do with why your suggestion failed as I got this
message:

Run-time error '3075':
Syntax error in string in query expression 'txtCustomerID=2"

So I thought maybe it had a missing operand like ( ' ) so I tried it this
way.

DoCmd.OpenForm "frmmCustomers", acNormal, , "'txtCustomerID = " &
Me.EditCustSelect & "'", , acWindowNormal

This opens the form "frmmCustomers" but only to the first record, not the
desired RecordNo which in the Run-time error message example above you can
clearly see it shows the value of the CustomerID

Thx again
Mick

Hello Mick,

With a numeric field it is:
...., "txtCustomerID = " & Me.EditCustSelect,...

Peter

http://access.xps350.com/

"Vacuum Sealed" <noodnutt (AT) gmail (DOT) com> wrote

Are you sure txtCustomerID is the name of the field in your table? I ask
because the txt prefix is usually given to a form's textbox control...

Peter, Stuart

Thank you both.

Peter, sweet, that works nicely.

Stuart, the (txt) is what I use to differentiate each area of my DB's:

qry = Query
tbl = Table
dsp = Display
txt = Txt/ControlField
ubc = UnBoundControl
mod = Module
frmm = Forms Parent
frms = Sun Form
rpt = Report

This way If I have similar names in each area it makes it easier to
identify.

Thx again.
Mick