Subform question.

[calvinle]

Hi,

I have a subform on my main form, and I am wondering which one will be better to work in multi user way. By using a parent/child link to load the subform data from a combobox, or by filtering the data base on the combobox?

Which one is faster?

Thanks

 

[The_Doc_Man]

Those sound like two unrelated options. The traditional way involves parent/child linkages. To filter the database, you still would need some way to specify the filter, wouldn't you?

 

[calvinle]

Yes.
I was saying is it better that I set my subform parent/child link to show the data after a combobox is chose.
Or using vba, to just filter the data in the subform base on the combobkx.

I know the difference is when you add data to the subform.
Using parent/child link, when you add new data, it will automatically add the parent field data to it vs the filter, you need to program it.

But my main concern is more about the peformance. Im having 2 database, 1 i use filter and no issue. The other one I use parent/child and seems to be slower on multi-user environement.

 

[The_Doc_Man]

The issue is actually of the nature of "pay me now, pay me later." Using parent/child, you pay at the time you select something. Using pre-filter, you pay when you open the parent form.