Replies

Thank you Charlotte and all the other great folks who participate in this wonderful forum.

Adding the Select statement before the requery almost worked. Now I still see the data related to the first record, in each list box, but if I click on any field for a particular detail record, all occurrences of the list box change to display the data related to the “clicked” record. This is better, but I was hoping to be able to automatically display data related to each record, right next to that particular record. Apparently the list box is only “pointing” to one piece of data at a time and just repeating itself for each of the continuous records on the form. This is not how I want this form to look. Any other ideas?????

Francois, I tried your solution but it still repeats the data related to the first record. Maybe this isn’t possible with continuous records??? My subform is named frmSubTwo, and it displays continuous records based on one query (works fine). This subform also has a list box named List99, which uses a select statement against a different table (but with a related field). As I mentioned before, the data displayed in this list box is correct for the first record, but this same data displays for all subsequent records on the subform. On the ‘On current’ event of the subform (frmSubTwo) I have the code: Me.List99.Requery
Anything else I should try?

Thanks for your help.

Thank you! I have one more question about appending the records to the master table. Can you make the append, only import new and changed reecords? I did not want to import all records each time, but I also, did not want to only import new records, because then I would not get any pre-existing records that have been edited.

Thanks Mark!

I use the dates when I run reports, and sometimes I would only need the 10th date. I have to count the records before choosing a date. Can you number the records in a query? If so, I could add this to the query my form is based on and then add this new field to my form. Any suggestions would be greatly appreciated.

Hello? Please, somebody help me.

I have a parent form with subform and button on parent form. User selects record in subform then clicks button on parent form. Button opens another form, going to (or preferably filtering to) a record (or records) related to the subform record. Does this make more sense now?