Hey guys, thank you all SO much for your responses!
It turns out the problem was two-fold.
First:
Using db.execute SQLstring didn't work; that was part of the problem. Changing it to DoCmd.RunSQL SQLstring made it happen. Thanks for the tip, checoturco. :)
Second:
The (now) executing...
Izy, thank you so much for your reply. I appreciate the investigation.
I'm sorry about not being complete enough in the information provided.
While both PID and SID in the code house numbers, the field is data type "text" because of the way the data is stored right now. However, I can easily...
Hello, All:
I have a database wherein two tables are related by a field called "sno"; it is an automatically generated number in table1 and in table2 it's a number field. It's the primary key in table1, also.
I have a form that contains a few textboxes:
user (autopopulated from another form...
Thanks for the response, Supercharge.
I have a small update to make; I added a text box to the form, and populated the text box with the variable I used to store the recordsource of the second list box. That works fine; now everything in the second list box is going into the appropriate table...
Happy Halloween everyone!
This is my first post, but I've been lurking for sometime. I'm grateful for all the great advice given here; despite my efforts, I can't find anything directly related to what I'm doing, though.
I have a form that is populated from a query. The query has some...