Ok.. (First off, my Form is using this Search method http://access-programmers.co.uk/forums/showthread.php?t=65331) On my Form there is a listbox with 4 different fields: JobID, CustomerID, InvoiceID, and Piece Done (Referring to piece of furniture) And each field takes information from the tblJobs table. There are also corresponding textboxes for each field in the listbox, named JobID/CustomerID/InvoiceID/Piece-Done, respectively. So I have my Form already built and the search function is working well enough, but there is still something i can't figure out. After I search and the record I want is found.. I want to be able to click on it and have the data from that record auto-populate into it's respective textbox. Any ideas or help as to how to do this? Thanks in advance.
*Edit* And also, when I'm working on my form in Design View, the Field List icon is faded out and can't be clicked on and I can't get it to pull up. What's the deal with that.. Anyone know?
*Edit* And also, when I'm working on my form in Design View, the Field List icon is faded out and can't be clicked on and I can't get it to pull up. What's the deal with that.. Anyone know?
Last edited:
