Subform datasheet record selection

G

Gary

I currently have a form with a subform which is set to
view as a datasheet which shows mutiple records for the
record set on the mainform (1 to many)I am trying to
select a record in the subform and have the mainform
update, which works with the following code. However the
subform reverts back to the first record not the selected
record. I think that this can be resolved with the use of
Recordsetclone but have been unable to make this work.
Help!

Forms!frmAELog!.Filter = "AENumber=" & Me![AENumber]
Forms!frmAELog.FilterOn = True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
Unremovable horizontal scroll bar on subform 1
Using a datasheet subform as record selector 0
Counting in Subform 3
Highlight rows in a subform datasheet view 0
Can't edit record in subform datasheet view. 1
Adding data to MS Access from csv file 0
data entry in subform before mainform causes huge hassle, HELP! 2

Top