I am creating a form which has 6 combo boxes referring to the same dictionary.
However, since there are 5,000 + records in that dictionary, the form shows up
very slowly. I would like to know whether there is any way I can speed up
the program?
My another question is that. I need to create a form that involves fields from
5 different tables. The parent table has two fields, customer_id which is also
a "primary field, and customer_name. Child tables are updated daily when
necessary. However, when the user input the data, he/she will not know whether
the customer is an existing one or not. But since the customer_id is defined as
"primary", there will be an error when inputing an old customer_id. Is there
any good way to get around? One way I can think of is to leave the Controlsource
empty and check whether the customer_id is already exist. If yes, then check
whether the customer_name is matched with the input. If both are true, then
pass the data to the corresponding fields when "lost focus". Is it a good way
to do it?
My last question is that when a new customer is input, only the fields corresponding
to the parent table are active. None of the child tables allow me to input.
I try to tackle this problem by "APPNED BLANK" for each child tables whenever
a new record is input. However, as I mentioned before, not all the child tables
need to be input. If I create a new record for each child tables, I will turn
out having a lot of empty records. Any suggestions?
I am sorry for this long messages.
C.L. Chu
cxc31@pyrite.cwru.edu