Hey there,
I have an Access Database that formulates a part code from multiple combo boxes within a form.
Each of these combo boxes is referenced one after another in "txtPartID" where the part code is put together.
I want to use this part code as query criteria, to search for the relevant spares part.
The query criteria i have come up with is
[Forms]![frmCodemaker]![txtPartID]
I have tested known data as a code for the query, and it has returned no results.
I then want the output of this query to show in another text box.
underneath the txtPartId text box, this will help the quotation system i'm developing.
Tried to upload the .db as an attachment, but it wasn't playing ball
Kind Regards
Joe