slackda
05-17-2007, 05:30 AM
Hi,
it's been a good few years since i have used Access and my memory seems to be failing me hope some one can help:
im trying to set a feild that Selects a value from a dropdown box with a set of values , whihc is defined by the results of a previous field selection.
i.e i select an employee from drop down list the next field is the National insurance number, which i want to auto populate based on the answer from the previous table.
also along the same route im trying to make a similar table that when you pick a particular brand of motor car it will populate the next drop down field/box based on the models avalible to that brand.
in both cases i have seperate tables, i presume that i need to make some quieries and some vba code to allow the correct selection but i really don't know where to start.
oh the joys of trying to make p11'd easier
thanks
slack
it's been a good few years since i have used Access and my memory seems to be failing me hope some one can help:
im trying to set a feild that Selects a value from a dropdown box with a set of values , whihc is defined by the results of a previous field selection.
i.e i select an employee from drop down list the next field is the National insurance number, which i want to auto populate based on the answer from the previous table.
also along the same route im trying to make a similar table that when you pick a particular brand of motor car it will populate the next drop down field/box based on the models avalible to that brand.
in both cases i have seperate tables, i presume that i need to make some quieries and some vba code to allow the correct selection but i really don't know where to start.
oh the joys of trying to make p11'd easier
thanks
slack