G
Guest
On my data access page the user will select from a list of suppliers from a
combo box that derives the list from a Suppliers table. Once this is done I
want the text boxes below to automatically fill in with address, phone
number, contact etc, which is also derived from the Suppliers table. I want
all this info to write to a seperate table (which I called NMR), since there
are many other fields on the page that needs to be written to this NMR table.
I see this discussion has already been beaten to death here but for some
reason, I just can't get it to work! I think the methods discussed here
pertain to Access forms, but I'm trying to get this to work on a data access
page. I really appreciate any help on this!!
combo box that derives the list from a Suppliers table. Once this is done I
want the text boxes below to automatically fill in with address, phone
number, contact etc, which is also derived from the Suppliers table. I want
all this info to write to a seperate table (which I called NMR), since there
are many other fields on the page that needs to be written to this NMR table.
I see this discussion has already been beaten to death here but for some
reason, I just can't get it to work! I think the methods discussed here
pertain to Access forms, but I'm trying to get this to work on a data access
page. I really appreciate any help on this!!