Current date

[Wantula]

I want the current date to be the default value on the date field of my form,
is this possible, how do i achieve this?

The other question is, how can I enter data in one table and have the same
data automatically entered into another table. The first table(STOCK) has
these fields [ Item and Quantity] and I want the Item field contents to be
automatically entered into the another table(MASTER) as they entered in thie
STOCK table.

 

[Ken Snell [MVP]]

You can either set the Default Value property of the field that is bound to
that control, or the Default Value of the control itself.

Likely, you'll want to use the latter method. Open the form in design view,
click on the control, click on Properties icon on toolbar, and click on Data
tab. You'll see Default Value there. Put this expression in the box next to
it:

=Date()

 

[Ken Snell [MVP]]

Regarding the second question....

It generally is not good practice to store the same data redundantly in your
database. What are you wanting to do here? Is Stock a child (related) table
for Master? Or the other way around? Or are they two completely independent
tables? If they're independent, what are their uses/purposes?

I ask these questions so that we can suggest the best methods for what you
want to accomplish.