Default Data Point

M

Midland

I am working on a data entry process with these compenents:

Table: GMachine
Query: Inqry
Data entry form: MachineInput

I enter the set-up time for a process as part of the data, in the form
control "SetUpf" for the field "SetUp", which is copied to the query. The
Downtime for the record, "A" is usually equal to the set-up, but sometimes is
not. How do I make the just-entered value for "SetUpf" or "SetUp" the default
for "Adf", the date entry control for "A"?
 
M

Midland

Hmmm . . . I'm entering a period of time--in minutes--not the time of day.
Thanks, though. You prompted me to scope the Discussion topics and the key
issue seems to be that defaults are triggered when you first open the record,
and an event that occurs during data cannot effect a default. That sound
about right?

Does someone publish a reference guide that lists the control properties all
at once, with definitions, etc.? My texts tend to introduce a topic, then
mention a property that might be relevant, then go on to another topic that
may or may not reference another property or class of properties, and so on.
None of them, for instance, list all nine data properties for a text control
and provide information on all of them at the same time.
 
K

KARL DEWEY

I'm entering a period of time--in minutes--not the time of day.
Access DataType DateTime stores a point in time.
To store number of minutes you need a number field.
 
M

Midland

Ah, so I added a spelling error to my list of confusions.

"How do I make the just-entered value for "SetUpf" or "SetUp" the default
for "Adf", the DATA entry control for "A"?"

Sorry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top