Accessing a Form w/ Subform and get "value" pop up.

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

Guest

My start form has a combo box with multiple locations listed. Next to the combo box, I put a Information cmd button to lookup the specific information on the location. The combo box gets it's values from a lookup table

The second form being accessed by the command button contains the specific details on the location and also has a subform with an individual point of contact. Because this individual contact can be referenced by several locations, the names had to be in it's own table. I therefore created a one-to-many relationship.

The problem is when I'm on the top form and click the information button, I get a pop up window with a "value" question with a reference to the sub form. If I click OK, it works fine. If I click Cancel, the sub form doesn't show up

How can I get rid of this darn pop up box? The value in the combo box on the primary form does have a relationship with the referenced "parent" form and the sub form. They all get their values from the same lookup table

Geeze, I hope this sounds less confusing than it was to type.
 
Guy,

It sounds like Access is asking you for a parameter value. This is info it
needs in order to do a query for the form that is about to open. Take a look
at the form's record source in design view. Then try it in datasheet view. I
bet you get the same dialog.

What's going on is that one of the columns in your query has null values in
some of the records. To show all of records in the query--even the ones with
null values in that one column--change the relationship line to an arrow,
pointing one way or the other, until you see all the records (and no
parameter value dialog) in datasheet view.

Hope that helps,
Brad H.


Novice guy said:
My start form has a combo box with multiple locations listed. Next to the
Click to expand...
combo box, I put a Information cmd button to lookup the specific information
on the location. The combo box gets it's values from a lookup table.
The second form being accessed by the command button contains the specific
Click to expand...
details on the location and also has a subform with an individual point of
contact. Because this individual contact can be referenced by several
locations, the names had to be in it's own table. I therefore created a
one-to-many relationship.
The problem is when I'm on the top form and click the information button,
Click to expand...
I get a pop up window with a "value" question with a reference to the sub
form. If I click OK, it works fine. If I click Cancel, the sub form
doesn't show up.
How can I get rid of this darn pop up box? The value in the combo box on
Click to expand...
the primary form does have a relationship with the referenced "parent" form
and the sub form. They all get their values from the same lookup table.
 
I think I know what you are talking about and made changes
to ensure all columns in the tables had a value. This
apprach didn't work.

What seems to be happening is when I click the Info cmd
button, Access doesn't know what "location" to associate
the individual point of contact to. Even though I have
the relationship created, it seems to want more
information. The top of the Pop up box says "Enter
Parameter Value" and references the sub form and field
that links the subform to the parent.

If I leave it blank and hit "OK" it the proper name is
referenced and everything seems to work fine. If I
hit "Cancel", the sub form doesn't appear.
 
You said:
I think I know what you are talking about and made changes
to ensure all columns in the tables had a value. This
apprach didn't work.
Click to expand...

It's ok to have null values fields, you just have to make what's called a
left- (or right-) join. That's the type of relationship between two tables
as you view them in query design view. (The query I mean is the one that
your subform is based on). Read Access Help for more info.

The other thing to check is that your Link Child Field and Link Master Field
make sense to relate the form and subform together. You can find these
properties on the Data tab in the Properties dialog for the subform.

But I bet if you look at the query you are using as the Record Source for
the subform, you will find that this query is doing the asking for the
parameter value, and that a left-join (with an arrow) will solve you issue.

Good luck.
Brad H.
 
Back
Top