using single form to update multible tables... 1

[iteach2]

I am pretty new to access 97. I used the form wizard to create a form. I would like to set a text box named "start date" up so that it updates a field in another table with a field called "start date". I am doing this so i can have one table hold "user info" and another hold "start and end times, in hopes that i may run a date range query and out put to a report that combines other selected info....all reponses are greatly appreciated...

 

[KenG]

Do these 2 tables have a field in common? In other words have you defined a relationship between the 2 tables?
If you have a relationship, select the fields from both tables that you want. Then the wizard should ask you how you want to link your form to the subform.
Hope this helps

 

[maic]

if you are willing to use VB 6. you can an ADO control, create a form to match your criterias (labels,text boxes),connect the ado to the database or databases(there are sql preferences), and link the text boxes to the appropriate fields. If your interested inrunning a vb app, I'll be happy to guide you every step of the way.

 

[iteach2]

Thank you KenG and thank you Maic for your responses. I am going to try both of your suggestions. I am creating a data base that tracks changes and upgrades made to various servers. I have a form linked to a table called tblChange. The fields look like this

Change# Status Requester Type Contact# StartTime EndTime

StartDate EndDate


The table has about thirteen fields. Should I break the table up into smaller tables? Also, I would like to create a form that can select date ranges and produce a report based on that criteria.
-------------------------------
Also, the Status will contain the following data(pending, completed, failed) how do i print a report that pull an entire record based on the status(pending, completed or failed etc----

Maic can you expound on the SQL and ADO method you talked about?

Thanks Ya'll
(Helplessly New to Access)