Thanks for answering. My original code gives me: Runtime error 13 Mismatch. It was some code I found that I was playing with.
Basically, what I am trying to do on my form:
1) Select a program from a combo box
2) Enter a part number in a text box
The textbox after update event :
If part number and program on form = part number and program in table then return a message, otherwise...
Davism4
Last Activity: Oct 14 '22, 02:54 PM
Joined: Jun 17 '21
Location:
-
Davism4 started a topic Match two fields in a table against a combo box selection and a text box entry / 2 fields on a form.in AccessMatch two fields in a table against a combo box selection and a text box entry / 2 fields on a form.
Hi All,
I have a table NonReworkablepa rts with 2 fields of interest , Program Number and PartNo.
On my form the idea is to select a program number from a combo box and when I type in a part number if it is in the table then it gives out a msgbox.
There will be multiple part numbers, that's why I need to make sure I match against the program also.
I've been playing with DLookup, but I've... -
Thanks for your reply.
I'm making a basic booking in and logging repair system.
I've been able to get by so far using the one table by using a 'status' field which i can query off - as the record tracks through the possible stages, eg maintenance complete- returned, booked in for repair, decommissioned etc...
What i am trying to do now is just put together a general history screen for any given serial number....Leave a comment:
-
List, form and a search box
Hi all,
Can I pick your brains please?
I need to a scan a serial into search box to return it's records of repair into a list box.
There will be more than one record against the same serial.
I want to be able to select a repair job from the list box to view the full details in the form below.
The db is only using 1 table.
What would be the best method of setting this up?
...
No activity results to display
Leave a comment: