By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,557 Members | 1,423 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,557 IT Pros & Developers. It's quick & easy.

synconize subform to main form

P: n/a
Ok let me explain what im trying to do:

i need a combo box which needs to be linked to a listbox (or combo box
doesnt matter which really) then the listbox should bring up the record
in a subform.

so you pick a name (in the combo box in the main form) then it should
bring up all the dates for which the person has a record for (in the
list box or combo box) and then once you pick a date it should bring up
the specific record you want for the date you choose

what i treid to do was put the NAME cobox box in the main form, link it
to a subform with the DATE listbox and then have subform inside that
subform with the record.

none of that worked. i cant figure out how to link the subforms. can
anyone give me a simple awsner to this problem

i havent used acess in over a year so im VERY rusty. i know it has
somthing to do with the childlink/masterlink propertiers (or think it
does) but i cant figure out how to edit them

any help would be much abliged

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
I will try to help you out with this one.

One approach - use linking between the main form and subform

First address the issue of the linking of the subform. There will need
to be a common field in the recordsource of each form. So for example,
if you are linking on a person, maybe there is a unique ID that can be
assigned, such as SSN or Employee ID.

With these two fields in each form, go to the properties of the subform
from the main form. (click on the outside edge of the subform while the
main form is in design view)

Second, on the main form, build a combo box using the combo box wizard,
and choose the option to Find a record on my form based on the calue I
selected in my .....

This will write the VBA to jump around from record to record based on a
selection from the combo box. With the linking set up, when the main
form changes the details in the subform will change along with it.
Another option..

If for some reason you cant link the subform, you could always have the
datasource of the subform reference the combo box on the main form, and
on the after update event of the combo box requery the subform. This
isnt the ideal way and could be more complicated.

Let me know if this helps?


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.