UltimateNeo
New member
- Local time
- Today, 12:03
- Joined
- Apr 29, 2024
- Messages
- 18
Hello,
I have a table with an ID field and a text field the user enters the text and i want to find the id for that text in my table stampnoT
text field is stampno
In another table called stampholdert i have the ID as a foreign key called stampnoid this is bound the id field
i want to open the form displaying the record in the stampholdert
at the moment i get ????????? instead of the replicationID value to use
code stampID = Nz(DLookup("ID", "StampNoT", "StampNo='" & UCase(StampSearch) & "'"), "")
DoCmd.OpenForm "NewuserF", , , "StampNoID={" & stampID & "}"
NewuserF is a cotinuous form and has the StampNoID field
Stampsearch is a textbox where the user enters the stampno they want to find
Thank you for any help
I have a table with an ID field and a text field the user enters the text and i want to find the id for that text in my table stampnoT
text field is stampno
In another table called stampholdert i have the ID as a foreign key called stampnoid this is bound the id field
i want to open the form displaying the record in the stampholdert
at the moment i get ????????? instead of the replicationID value to use
code stampID = Nz(DLookup("ID", "StampNoT", "StampNo='" & UCase(StampSearch) & "'"), "")
DoCmd.OpenForm "NewuserF", , , "StampNoID={" & stampID & "}"
NewuserF is a cotinuous form and has the StampNoID field
Stampsearch is a textbox where the user enters the stampno they want to find
Thank you for any help