Re: Linking Sub Forms

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Ok. Thanks.

Like I said, it works. I just have to say no to error and there it is, all
linked up fine. I'll get it nailed down eventually. Thanks

"Jeff Boyce" wrote:

Sorry I couldn't help more. I haven't done it the way you are trying to...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Mixer1" <Mixer1@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EC8B5A0D-14C6-4D80-AC8A-7A8FE2844BBC@xxxxxxxxxxxxxxxx
In my first paragraph I saif one of my forms is a subform. I meant one of
my
forms I need as a subform is a Continuous form.

"Jeff Boyce" wrote:

There may be an easier way to get a set of "details" loaded into a form,
based on a selection...

When I need to do this, I create a form based on a query, the query based
on
the table. This is just a starting point. This form, as described, is
loaded with ALL the rows of data, and you could scroll through it (but
that
isn't a very easy way to find records).

Next, I add an unbound combobox (i.e., it doesn't refer to any of the
fields
in the query) in the header of the form. For the Row Source of the
combobox, I use a (small) query that only returns the RowID and one (or
two)
of the fields from the table, used only to help me identify WHICH row I
want
to look at the details on.

Then I modify that first query to "point" to the combobox on the form for
a
Selection Criterion for the RowID field (in other words, telling the
query
to find the row that has the RowID in the combobox). To get this to
work, I
also have to tell the combobox to re-run the query to re-load the form.
In
the combobox's AfterUpdate event, I add:
Me.Requery

Now, when I open the form, there's nothing in the combobox, so the query
that loads the form has no RowID and returns that record (i.e., no
record).
I select one of the items from the combobox and tab out of the control,
and
the combobox's AfterUpdate tells the form to requery its source ... and
now
the query DOES have a (selected) row and returns that to the form.

I realize this might sound like a lot of work, but trying to get two
continuous form subforms to coordinate and do the same thing will be even
MORE work!

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Mixer1" <Mixer1@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7FCC8641-C1A0-4DD2-98E2-FA5871481FD7@xxxxxxxxxxxxxxxx
I am really missing something on some basic of sub forms. I need help.

I want to set up a form that has two subforms. The form will not
conatin
anything. One subform will be the names of every item in the table in a
comtiusous form.

As someone clicks their mouse on one item in the continsuous form, I
want
details of that item to shou up in a second subform, in individual form

Both subforms will be based on info in the same table, even!

Where in the second subform, the one with all the details to I tell it
to
lo
look at what item is selected in the firsat subform.

As I move up and down the contiuous form on the left, I want the
details
of
that item to show up on the ind. form on the right.

Thanks. Be nice, I'm sortof new at this. Can't you tell??






.

Relevant Pages

  • Re: Combo box concatenation of fields
    ... list can show more than 1 column, but the combobox control itself can ... calculated field in the query something like this... ... and then have a column on the subform bound to this field. ... >>>student ID, last name, first name,phone, student type, and grade. ...
    (microsoft.public.access.forms)
  • subform combobox filter problem
    ... I have created a bound subform on an unbound masterform linked together ... what you see when you select a store is a list of all the ... I have created a combobox bound to a field on the ... subform's query (simple query on a single table sorting items ...
    (comp.databases.ms-access)
  • subform combobox filter problem
    ... I have created a bound subform on an unbound masterform linked together ... what you see when you select a store is a list of all the ... I have created a combobox bound to a field on the ... subform's query (simple query on a single table sorting items ...
    (comp.databases.ms-access)
  • Re: Linking Sub Forms
    ... When I need to do this, I create a form based on a query, the query based on ... Next, I add an unbound combobox (i.e., it doesn't refer to any of the fields ... Selection Criterion for the RowID field (in other words, ... details of that item to shou up in a second subform, ...
    (microsoft.public.access.forms)
  • Re: Access forms question from a newbie
    ... One approach would be to base the form on a query against the table. ... use the form's combobox value as a criterion for the rowID ... The criterion would look something like: ...
    (microsoft.public.access.formscoding)