By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,037 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

Autofilling a form with default values

P: 1
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,EnteredDt need to be entered and not all of the other information.

Please help..

Thank you.
Aug 21 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 112
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.
Aug 21 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.