2 basic questions from a relative beginner (i'll probably have mor

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

1. As I understand it, a form can be based either on a single table
(permitting controls bound to that table's fields only) or on a query
combining multple tables/queries and allowing controls to be bound to any of
them. Is this correct, not counting VBA coding?

2. I find that a default value specified in the table will show up on the
form if it is based on the table directly, but not if it is based on a query.
How can a form contain controls bound to different tables and still display
the default value?

3. Thanks very much for any enlightenment.

FR
 
Dear FR:

1. That is correct, although some queries that combine multiple
tables/queries can be non-updateable...
2. Setting a default value for a control means that when a *new* record is
created the control will be given that value. It doesn't affect existing
records. I'm not sure, but does this explain the situation? I suppose it
might also be that you might be running into the non-updateable situation as
mentioned above.

HTH
Fred Boer
 
FR said:
1. As I understand it, a form can be based either on a single table
(permitting controls bound to that table's fields only)
Click to expand...

The control source can also be an expression - eg. [Price] * [Qty] to
display a total.
or on a query
combining multple tables/queries and allowing controls to be bound to
any of them. Is this correct, not counting VBA coding?
Click to expand...

A form can also be 'unbound' - with no record source.
2. I find that a default value specified in the table will show up on
the form if it is based on the table directly, but not if it is based
on a query.
How can a form contain controls bound to different tables
and still display the default value?
Click to expand...

If you are having trouble, you can always set the default value property on
the control in the form. In fact you can use this to override the table's
default value.
 
Back
Top