Open form to specific record based on text box on navigation form

[Sticky99]

Hi Guys, I'm trying to open a form to a specific record, I have a navigation form with a button and text box where i can input the specific record number, although the form opens, it always opens to a new record, I'm using the following to open the form.

DoCmd.OpenForm "frmDeliveryNote", acNormal, "", "[DeliveryNoteID]=[Forms]![frmDNote]![txtSearchDNote]", , acNormal

can anyone throw some light on why the from doesn't open to the specific record.

Cheers

 

[Gasman]

Try removing the "" for filter and just leave the WHERE clause.
Remove the last acNormal as well.?

DoCmd.OpenForm syntax

 

[theDBguy]

Hi. On a different note, have you tried using the BrowseTo method instead?

 

[Sticky99]

Hi Gasman,
is this what you mean

DoCmd.OpenForm "frmDeliveryNote", , , "[DeliveryNoteID]=[Forms]![frmDNote]![txtSearchDNote]"

 

[Sticky99]

Hi. On a different note, have you tried using the BrowseTo method instead?

Tried this but couldn't get it to work!

 

[Gasman]

Hi Gasman,
is this what you mean

DoCmd.OpenForm "frmDeliveryNote", , , "[DeliveryNoteID]=[Forms]![frmDNote]![txtSearchDNote]"

Yes, but you should only have two commas I believe.? Check that syntax link I posted.

 

[theDBguy]

Tried this but couldn't get it to work!

If you can show us how you tried it, maybe we can show you how to fix it.

 

[Sticky99]

If you can show us how you tried it, maybe we can show you how to fix it.

This is what I have
DoCmd.BrowseTo acForm, "frmDeliveryNote", "", "[Forms]![frmDeliveryNote]![DeliveryNoteID]= [forms]![DNote]![Text1]", "", 1

 

[theDBguy]

This is what I have
DoCmd.BrowseTo acForm, "frmDeliveryNote", "", "[Forms]![frmDeliveryNote]![DeliveryNoteID]= [forms]![DNote]![Text1]", "", 1

Hi. I think maybe that should have been more like:

DoCmd.BrowseTo acBrowseToForm, "frmDeliveryNote", , "DeliveryNoteId=" & Me.TextboxName

 

[Sticky99]

Hi. I think maybe that should have been more like:

DoCmd.BrowseTo acBrowseToForm, "frmDeliveryNote", , "DeliveryNoteId=" & Me.TextboxName

Thank You!!! it worked.
Thanks DBguy,
Much appreciated, I can sleep tonight.
Really great to be able to call on you guys for help.

Again, thanks.

 

[theDBguy]

Thank You!!! it worked.
Thanks DBguy,
Much appreciated, I can sleep tonight.
Really great to be able to call on you guys for help.

Again, thanks.

Hi. You're welcome. Glad we could assist. Good luck with your project.