Parameters in Queries

  • Thread starter Thread starter nChicago
  • Start date Start date
N

nChicago

Is there a way that I can pass values in and out of Queries via Macros?
While messing around with Queries, I noticed a parameter table, how do you
populate it with values?

Thanks.

N
 
Lynn,

I have two situations:

A. I have a list of records in a form. I would like to double click on a
record and open a new form showing the entire record detail in edit mode. I
want to make sure that the new form contains the record that was originally
double clicked.

B. I have a form with a record detail and a sub-form with child records. I
would like to click on a child record in the subform and open a new form
with the record detail. I want to make sure the new form opens with the
data from the child record such that it is editable.

I was hoping to create queries for each of the situations and parameterize
the Primary Key for the record double clicked and pass it to the query as a
paramter.

Any advice or help?

Thanks.

N
 
A. I have a list of records in a form. I would like to double click on a
record and open a new form showing the entire record detail in edit mode.
I want to make sure that the new form contains the record that was
originally double clicked.
Click to expand...

I'm not totally sure I understand you. Why do you need to open a second form
that contains exactly the same record as the first form? Just put the first
form in edit mode.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html
 
Lynn the first form contains a list of records. It only contains a subset
of the fields the form actually contains. It is meant to provide a brief
summary of information.

The detail form contains all of the forms fields and allows the user to view
and edit all of them. There are too many fields in the record to
conveniently edit in a list / table of records format, therefore, a detail
form is needed.

N
 
Lynn,
That's a very interesting idea.
How do tabs work?
When I click a tab, will I be able to have the record selected in the
subfrom (which is a list of child records) visible in the new tab as a
detail record?

thanks.

Neal
 
Back
Top