Automatic Entry of Data into form

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

In summary, I need to place a button on a form, that when
clicked, will enter details on the open form from a table
that is not the underlying table of that form.

Details:- The form has a field that asks for a postal
address to be entered. There are default address details
in another table, that I would like to automatically be
entered into these controls at the press of a button.

The aim of this is to allow a default postal address to be
automatically entered.

Can anybody help?
 
The simplest I can think of is to temporarily bind the form to the table
and requery it, then remove the record source value again.
Alternatively, you could open a recordset in code using your table as
the record source, and then populate the unbound controls on the form in
a loop. This is more coding but you will have a "truly" unbound form.

Pavel
 
Back
Top