Updating a table using a form

radicalrik

Registered User.
Local time
Today, 12:53
Joined
Apr 23, 2004
Messages
23
How would I go about updating a table from a form? My table consists of employee contact information, ie.. Cell phone, pager number, home phone.
I have created a forum with unbound combo box called employee. As I choose the employee name all other fields are populating just as i want. After I update the form with the correct system contact information i want to be able to save the data and have it update the table. It appears the only data not updating the table is the anything in the combo boxes that are unbounded. Any suggestions?
 
Last edited:
Thanks Pat for your input. It's good to know the code is right. LOL. Is there a way that I can take all the data on the form and perhaps send it to a new or existing Table so that I can query on on table as opposed to querying multiply tables in one query. Hope I'm making sense.

See, what my goal here is... I want the Oncall support people to be able to update the form, but I don't want them having to always type in there name, phone, pager ect.. That's why the combox box. They can click their name and the fields will be populated. Then all they have to do is change the System and Date fields, hit enter and all the information is saved into one Table. I will then create a query for the folks who would need to look this information up. Again, hope I'm making sense.
 

Users who are viewing this thread

Back
Top Bottom