Autofilling a form with default values

[cllark7]

Currently I am creating a database that has multiple tables. I would like to create a form that is populated with default values each time a new record is entered. Here is an example of what I mean.

Table 1 items:
ID
Item
Description
ReceivedDt
EnteredDt

I would like to have upon entering a new form to have Item and Description be populated each time to:
Product1 Description
Product2 Description

That way only the ReceivedDt,Ente redDt need to be entered and not all of the other information.

Please help..

Thank you.

[janders468]

The easiest way to do this depends on how you are entering the data. If the form is bound to the underlying table then I would set the default value property of the relevant fields to the relevant names (in the underlying datasource). That way any time a record is added it will be populated by the database. However, if you are using the input values as part of a query (i.e. you append those values as a record in the table) then you can either set the default value of the controls where this is input, or use code to set the values to what you are interested in.