Show list of data from query than can be selected.

[piperhayes]

I'm wanting to have a list with my subform that lists all of the table
entries for a particular individual (contact log). Easy enough with a
filtered query. Problem is that I want to be able to select a record from
that (synopsis) list and have that record made as the current record in the
sub-form, so that the record is easier to update.

Hope that makes sense.

 

[ruralguy via AccessMonster.com]

If it helps, when you select a record in a continuous form or SubForm, that
record becomes the current record of that form.

 

[piperhayes]

But how do I "populate" my subform with the record?

 

[ruralguy via AccessMonster.com]

Using the LinkChild/MasterFields properties of the SubFormControl.

But how do I "populate" my subform with the record?

If it helps, when you select a record in a continuous form or SubForm, that
record becomes the current record of that form.

[quoted text clipped - 6 lines]

 

[piperhayes]

My subform is linked to my main form by those fields and I can use the record
navigation buttons to pull up the records in the sub form. I was wanting to
have a list with selectible entries to populate the subform instead of using
the record navigation buttons on the subform.

Using the LinkChild/MasterFields properties of the SubFormControl.

But how do I "populate" my subform with the record?

If it helps, when you select a record in a continuous form or SubForm, that
record becomes the current record of that form.

[quoted text clipped - 6 lines]

Hope that makes sense.

 

[ruralguy via AccessMonster.com]

I'm sorry but I guess I don't really understand your configuration and the
requirements. Would a 2nd SubForm beside the 1st SubForm solve your issue?
Similar to this link:
http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

My subform is linked to my main form by those fields and I can use the record
navigation buttons to pull up the records in the sub form. I was wanting to
have a list with selectible entries to populate the subform instead of using
the record navigation buttons on the subform.

Using the LinkChild/MasterFields properties of the SubFormControl.

[quoted text clipped - 5 lines]

 

[piperhayes]

RG, sorry but the filter at my work will not permit me to open that web page.

I'm sorry but I guess I don't really understand your configuration and the
requirements. Would a 2nd SubForm beside the 1st SubForm solve your issue?
Similar to this link:
http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

My subform is linked to my main form by those fields and I can use the record
navigation buttons to pull up the records in the sub form. I was wanting to
have a list with selectible entries to populate the subform instead of using
the record navigation buttons on the subform.

Using the LinkChild/MasterFields properties of the SubFormControl.

[quoted text clipped - 5 lines]

Hope that makes sense.

 

[ruralguy via AccessMonster.com]

Would two SubForms side-by-side on your MainForm solve your problem? The
second SubForm would display additional information for whatever record is
selected on the first SubForm.

RG, sorry but the filter at my work will not permit me to open that web page.

I'm sorry but I guess I don't really understand your configuration and the
requirements. Would a 2nd SubForm beside the 1st SubForm solve your issue?

[quoted text clipped - 11 lines]

 

[piperhayes]

That would probably work. Was kind of what I was doing at first, but
couldn't get to work like I wanted, so I switched to a combo box to select
the record.

At the moment I'm looking at two tables.
Employees (contains employee info and employee id #)
Discipline (has linking field for employee id # and a seperate
autonumber record key)

Created tabbed form based on the employee table.
Added subform for discipline entries on second tab that is populated by
query of discipline table filtered by the entry on the main form for the
employeeid form field.

I've been successfull at creating an unbound combo box that filters the same
as the subform and brings up the desired record in the subform on the first
instance.
Problem - If I return to the first tab (main form) and change employees,
then return to the discipline tab
The discipline subform populates correctly with the selected
employee, but I can not get the combo box to populate for the currently
selected employee. It continues to show the list from the employee that was
selected the first time.

iepen form, selected employee 200, goto discipline tab, select combo box,
list is populated with employee 200's discipline entries, return to tab one
(employee form), select employee 100, goto discipline tab, select combo box,
list is still populated with employee 200's discipline entries yet if I use
the record navigation buttons for the discipline subform it is filtered
correctly for employee 100's entries.

Does this help?

Originally I was trying to do the same thing but with a querry of the
discipline table in a datasheet subform in addition to the discipline
subform, but couldn't figure out how to select a record in the datasheet and
have it populated in the discipline subform.

Would two SubForms side-by-side on your MainForm solve your problem? The
second SubForm would display additional information for whatever record is
selected on the first SubForm.

RG, sorry but the filter at my work will not permit me to open that web page.

I'm sorry but I guess I don't really understand your configuration and the
requirements. Would a 2nd SubForm beside the 1st SubForm solve your issue?

[quoted text clipped - 11 lines]

Hope that makes sense.

 

[ruralguy via AccessMonster.com]

Try adding a Me.ComboBoxName.Requery to the Enter event of the ComboBox,
using your ComboBoxName of course.

That would probably work. Was kind of what I was doing at first, but
couldn't get to work like I wanted, so I switched to a combo box to select
the record.

At the moment I'm looking at two tables.
Employees (contains employee info and employee id #)
Discipline (has linking field for employee id # and a seperate
autonumber record key)

Created tabbed form based on the employee table.
Added subform for discipline entries on second tab that is populated by
query of discipline table filtered by the entry on the main form for the
employeeid form field.

I've been successfull at creating an unbound combo box that filters the same
as the subform and brings up the desired record in the subform on the first
instance.
Problem - If I return to the first tab (main form) and change employees,
then return to the discipline tab
The discipline subform populates correctly with the selected
employee, but I can not get the combo box to populate for the currently
selected employee. It continues to show the list from the employee that was
selected the first time.

iepen form, selected employee 200, goto discipline tab, select combo box,
list is populated with employee 200's discipline entries, return to tab one
(employee form), select employee 100, goto discipline tab, select combo box,
list is still populated with employee 200's discipline entries yet if I use
the record navigation buttons for the discipline subform it is filtered
correctly for employee 100's entries.

Does this help?

Originally I was trying to do the same thing but with a querry of the
discipline table in a datasheet subform in addition to the discipline
subform, but couldn't figure out how to select a record in the datasheet and
have it populated in the discipline subform.

Would two SubForms side-by-side on your MainForm solve your problem? The
second SubForm would display additional information for whatever record is

[quoted text clipped - 7 lines]

 

[Zac]

Very interesting link, but how do you do that!?

I'm interested in creating that kind of a search box and I can't do it.
The user should be able to pick some criteria from combo box, and in next
text box type some letters for search, push the button and move to the first
matching record in form.

If you have some ideas, please share with me!

I'm sorry but I guess I don't really understand your configuration and the
requirements. Would a 2nd SubForm beside the 1st SubForm solve your
issue?
Similar to this link:
http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

My subform is linked to my main form by those fields and I can use the
record
navigation buttons to pull up the records in the sub form. I was wanting
to
have a list with selectible entries to populate the subform instead of
using
the record navigation buttons on the subform.

Using the LinkChild/MasterFields properties of the SubFormControl.

[quoted text clipped - 5 lines]

Hope that makes sense.

 

[piperhayes]

Thanks alot RG. That did the trick.
Is there a reference that shows what order or what triggers the different
events for a control?

Try adding a Me.ComboBoxName.Requery to the Enter event of the ComboBox,
using your ComboBoxName of course.

That would probably work. Was kind of what I was doing at first, but
couldn't get to work like I wanted, so I switched to a combo box to select
the record.

At the moment I'm looking at two tables.
Employees (contains employee info and employee id #)
Discipline (has linking field for employee id # and a seperate
autonumber record key)

Created tabbed form based on the employee table.
Added subform for discipline entries on second tab that is populated by
query of discipline table filtered by the entry on the main form for the
employeeid form field.

I've been successfull at creating an unbound combo box that filters the same
as the subform and brings up the desired record in the subform on the first
instance.
Problem - If I return to the first tab (main form) and change employees,
then return to the discipline tab
The discipline subform populates correctly with the selected
employee, but I can not get the combo box to populate for the currently
selected employee. It continues to show the list from the employee that was
selected the first time.

iepen form, selected employee 200, goto discipline tab, select combo box,
list is populated with employee 200's discipline entries, return to tab one
(employee form), select employee 100, goto discipline tab, select combo box,
list is still populated with employee 200's discipline entries yet if I use
the record navigation buttons for the discipline subform it is filtered
correctly for employee 100's entries.

Does this help?

Originally I was trying to do the same thing but with a querry of the
discipline table in a datasheet subform in addition to the discipline
subform, but couldn't figure out how to select a record in the datasheet and
have it populated in the discipline subform.

Would two SubForms side-by-side on your MainForm solve your problem? The
second SubForm would display additional information for whatever record is

[quoted text clipped - 7 lines]

Hope that makes sense.

 

[ruralguy via AccessMonster.com]

In Access Help (not VBA Help) key in "events" to the Answer Wizard.

Thanks alot RG. That did the trick.
Is there a reference that shows what order or what triggers the different
events for a control?

Try adding a Me.ComboBoxName.Requery to the Enter event of the ComboBox,
using your ComboBoxName of course.

[quoted text clipped - 42 lines]

 

[piperhayes]

There are many refrences to cascading combo boxes in this forum. I havn't
done one myself, but I would think that you create your first combo box to
filter part of your records, then use the results from that combo box as the
data source for your next combo box and filter it down more.

I'm a real beginner at this, but that's how I'd look at it.

Very interesting link, but how do you do that!?

I'm interested in creating that kind of a search box and I can't do it.
The user should be able to pick some criteria from combo box, and in next
text box type some letters for search, push the button and move to the first
matching record in form.

If you have some ideas, please share with me!

I'm sorry but I guess I don't really understand your configuration and the
requirements. Would a 2nd SubForm beside the 1st SubForm solve your
issue?
Similar to this link:
http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

My subform is linked to my main form by those fields and I can use the
record
navigation buttons to pull up the records in the sub form. I was wanting
to
have a list with selectible entries to populate the subform instead of
using
the record navigation buttons on the subform.

Using the LinkChild/MasterFields properties of the SubFormControl.

[quoted text clipped - 5 lines]

Hope that makes sense.