Forms - multiple record

[vince1818]

Hi Paul,

I uploaded the DB here. Whenever you get a chance, will you let me know if Im missing something? I keep trying but still couldnt figure out what's wrong with the barcode. I set up the same format of the control source from the main form and subform =Code1289([Table.Field]), but still the barcode in the subform is not readable.

Thanks in advance. Have a great day!

 

[pbaldy]

I looked at the db, but it wouldn't work at all for me because it appears to need the IDAutomation font loaded, which I don't have. I was hoping somebody that did would respond to this or your other thread on the same topic.

 

[vince1818]

hi Paul,

I was able to make it work! Since its a subform, in the control source, i didnt include the table in the code. I just included the field and it worked!

Anyway, for the DB, thank you for checking it out. I have a few questions though, the data in the DB I uploaded are actually from an ODBC. I linked the tables and made some relationships and run a query. So, in the DB, the Production DB and Copy Orders table are actually a query table. My question is, if I need to add new record and update the table, how can I do that? Or is there a simple way to do it? I hope i am making sense here, let me know if you have any clarifications. Again, thank you for all your help!

 

[pbaldy]

If you're saying the form is bound to a query rather than the table, you should still be able to update/add records presuming the query isn't read-only.

 

[vince1818]

The data in the form is from the table. nad the tables were generated from a query. So, before I designed the form, form the bunch of tables in the ODBC, I created a query then run it into a query table which is the Tables - Production DB and Copy Orders. Sorry for the confusion, my question is, since the original tables and query are linked ot the ODBC, if there are new records/updates in the ODBC tables, will the query table automatically updated as well?