Why is this?

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

Guest

Hello Programmers,

I have a subform that's bound to a table that has data in it. The subforms
Link Master/Link Child fields are hooked into the main form which is empty.
Although the table the subform is linked to has data in it, the data does not
appear when the form is open.

If I open the subform by itself the data appears, but not while it's in the
main form.

Why is that?

-Simon
 
If "Link Master/Link Child fields are hooked into the main form" means that
you have a field or fields listed in these properties, then you will only
see records in the subform that match the values in the main form. If there
is no value on the main form, there will be no records in the subform.
 
Simon said:
Hello Programmers,

I have a subform that's bound to a table that has data in it. The subforms
Link Master/Link Child fields are hooked into the main form which is empty.
Although the table the subform is linked to has data in it, the data does not
appear when the form is open.
Click to expand...

If the main form is not bound to a table then remove the
entries for "Link Master Fields" and "Link Child Fields" for the
subform.

The link details are for when there is a relationship between the bound
tables.
If the main form was to show Orders, the sub form to show OrderDetails.
Then ->
Setting the linking between the forms would mean that as you moved between
Orders on the main form, Access would show only the OrderDetails for
that order,

Regards John
 
Duane, John

A relational database is much harder to put together than one that just uses
one table. What I've been trying to do for the last month is:

1. Have a few employee details on a form ( Name, Dept, Job Title )
2. Display a list of manauls by department ( Admin, Clinical, ... )
3. Have the user select manuals from the list ( ListBox or Combo )
4. Assign the choices to employee John or Jane Doe

Q. Is this realistically possible to do for a novice in Access.

Please choose one or more of the answers below, be brutally honest.

(a) Hell no, just shoot yourself right now
(b) Maybe, if you work hard and beg for help
(c) Absolutely, just pay me what I ask and it's done
(d) Bring the vaseline, bend over and let me think about it a minute

I hope you guys have a sense of humor :-)

-Simon
 
Simon said:
Duane, John

A relational database is much harder to put together than one that just uses
one table. What I've been trying to do for the last month is:

1. Have a few employee details on a form ( Name, Dept, Job Title )
2. Display a list of manauls by department ( Admin, Clinical, ... )
3. Have the user select manuals from the list ( ListBox or Combo )
Click to expand...

Requires a separate table with columns/fields for EmployeeID and ManualID.

Are you recording individual manuals (like a lending library) ?
4. Assign the choices to employee John or Jane Doe

Q. Is this realistically possible to do for a novice in Access.

Please choose one or more of the answers below, be brutally honest.

(a) Hell no, just shoot yourself right now
(b) Maybe, if you work hard and beg for help
Click to expand...


(b) It's not what you don't know that's a problem for the novice but what
you think you know.

ie
If you are experienced in Access you should ask technical questions (forms,
relationships, datatypes...)
If you are a novice you should ask simple questions (Orders, Details,
Employees, Quantities...) and you
will find yourself technical questions soon enough.

Use the wizards - John
 
John,

I think I have a solution, but that's also what I thought about 3 or 4
versions ago :-)

Anyway, at some point we'll get it to work I think!
Are you recording individual manuals (like a lending library) ?
Click to expand...

Not exactly. I'm trying to help a friend who's just as much an amatuer as I
am. I felt if we both worked at it we could pull it off together. We've made
a lot of progress though. Were like the that song "Oh so close but yet so
far".
Use the wizards - John
Click to expand...

Yea, you know it. They help out a lot. We used it to split our tables and
create the relationships. Just a few more details and I think this puppy will
be ready.

Thanks a million John,

-Simon
 
Back
Top