connecting form to a table?

[MrLee]

I am relatively new to this and was wondering how to connect my form to a table?

Thanks,
MrLee

 

[ColinEssex]

Not sure what you mean. If you have created a form with fields on it then presumably you selected the fields from the fields list so the form is connected to a table.

You can check the record source of the form in the form properties (in design view, click the little grey box with a black square in it, it's in the top left hand corner of the form)

Hope this helps
Col


[This message has been edited by ColinEssex (edited 05-02-2002).]

 

[MrLee]

the problem I am trying to get around is to be able to grab the records from a table which holds data regarding fuel transactions. The data I am concerned about is the odometer readings...the transaction data comes into the database and updates the current odometer reading. The only problem is that there could be more than one transaction for each vehicle. But the way our system is set up is that it only updates the odometer readings with the most current odometer reading instead with every transaction. Which is why I am attempting to grab the data from the tables, do my calculations then re-connect and re-load the data back into the table.

sort of long winded,
thanks.

 

[ColinEssex]

Looks like you need 2 tables - 1 for the vehicle and 1 for the transactions. Have a unique ID (autonumber) for the vehicle and then have the same ID for each vehicles transactions and mileage etc. Then you can have as many transactions as you like and display them with a subform or whatever.

HTH
Col