J
johank
Guest
I'm converting a dBlll database, which has many duplications of member names . Amongst others, it must be able to
import member names from dBlll
Their personal details can be edited in Access 97 (later it will export to dBlll).
I've made Name and Address1 primary keys, both allowing duplicates; there is also an autonumber counter.
Problem: in a subform, 2 choices have to be made: Category and based on that choice, sub-Category.
As far as I know, Access 97 doesn't allow 2 columns to be bound in a combo box.
I've tried using the autonumber as master/child link between form and subform, so as to have to choose only one bound
column
The sub-Category will provide the link to the master/child link, and is based on the "one" table of a "many to one to
many" setup.
The second combo fails on the line "docmd.applyfilter", although in the debug window i can see the correct value output,
but it tells me there are numerous errors concerning the properties of the receiving field.
I'm not too hot on VB, try to avoid it where possible . . .
Cheers, Johan
