Subform Mayhem

  • Thread starter Thread starter DavidW
  • Start date Start date
D

DavidW

I know you can open a form from another form by "strwhere", but how do you
open a form and use the "strwhere" and refer it to a subform.
I have a form that has a record source of a query "adtype"(it looks at a
different table "setup"to sort a field "type"), the form has a subform
"adusage" that has a recordsource of a table "usage". What I am trying to do
is open the form by "pumpda" which is in the subform (pumpda is the name of
both textbox and field, it is the date for the record). Is this possible and
if so ,how do you do that?
Or is there a way to have a form without a subform that has a record
source of 1 table and be able to retrieve the list from the query to use as
a controlsource? I am trying to end up with a form in continious form mode
to list all of the entries in the query and use it for data entry.
 
Another Thought
Is there a way to populate a table before data entry with a list from a
query. Is it possible to take "veh" from a query "adtype" and put it into
the [usage]![veh] field before data entry?
 
Back
Top