Entering data in a table from a form

[Chris South]

Hi Guys,

I have a form based on a table, T_InitialData, when data is entered into the form it is saved to this table, however, I also need the data from three of the fields on the form to be saved to another table called T_Data. Can this be done easily? Basing the form on a query doesn't seem to work.

If so how?

Many thanks

Chris South

 

[dcx693]

Basing the form on a query doesn't seem to work.

If the query is the source for the form, and if the query joins the two tables in question in some way that makes sense, then that's the approach I would take. Why didn't it work?

 

[Chris South]

If the query is the source for the form, and if the query joins the two tables in question in some way that makes sense, then that's the approach I would take. Why didn't it work?

The form is based on a table. I have tried several different ways to use a query instead and it just doesn't want to work. One of the tables has a field called 'BaselinePIR', 'BaselineDate' I need these two fields to be entered into table T_Data in fields 'PIRValue' and 'TestDate'. The data for these fields is the same. Table T_Sensors and table T_Data are in a one-to-many relationship. I have tried changing the join properties to include all of T_Sensors and only some of T_Data but access wont accept data entry in thquery when you get to the T_Data fields. I must have access to all the records in T_Sensors for this to work.

Chris

 

[dcx693]

Can you outline the structure of these two tables? Sounds like you might do best with a form/subform type of arrangement.

 

[Thecherub]

why don't use an Append Query

Hi Guys,

I have a form based on a table, T_InitialData, when data is entered into the form it is saved to this table, however, I also need the data from three of the fields on the form to be saved to another table called T_Data. Can this be done easily? Basing the form on a query doesn't seem to work.

An append query might be what you want just pull the data you want in T_data from the Form based on T_InitialData. If you want them in different feilds then just make sure that your where statments are directed corectly. But don't ask me how to pull that Data from the forn to the query I can't get that to work with my own db yet.