C
compostdave
Hi,
I've got a subform into which the users type comments about events they've
attended. The comments are being recorded in tblEventFocus and this works
fine. However I'm trying to add a combo box to the subform which
automatically selects the correct user from the list and records the name in
the AdviserName column in the table (I know my structure isn't the most
efficient but it works the record is required as each user exports data,
emails it to a central location and then its imported into the master
database - long winded but necessary as the team are spread across the uk and
don't always have network access).
I've set up the combo box to source the value from tblAdvisers using SELECT
tblAdvisers.AdviserName FROM tblAdvisers; in the row source. AdviserName is
the primary key in tblAdvisers.
In the other forms which are being used to collect data, the combo boxes
automatically record the adviser name as selected on the menu form. As far as
I can tell I'm using exactly the same function on the subform with this combo
box as I have on all the others (there are 3 other forms which record data
against the adviser name in other tables without having to select the name
each time) however I just can't get the combo box on this subform to auto
populate (I've tried everything I can think of including copying and pasting
the combo boxes across, and trawled the net for suggestions but still can't
get it to work). Any suggestions would be much appreciated.
Thanks in advance
Dave.
I've got a subform into which the users type comments about events they've
attended. The comments are being recorded in tblEventFocus and this works
fine. However I'm trying to add a combo box to the subform which
automatically selects the correct user from the list and records the name in
the AdviserName column in the table (I know my structure isn't the most
efficient but it works the record is required as each user exports data,
emails it to a central location and then its imported into the master
database - long winded but necessary as the team are spread across the uk and
don't always have network access).
I've set up the combo box to source the value from tblAdvisers using SELECT
tblAdvisers.AdviserName FROM tblAdvisers; in the row source. AdviserName is
the primary key in tblAdvisers.
In the other forms which are being used to collect data, the combo boxes
automatically record the adviser name as selected on the menu form. As far as
I can tell I'm using exactly the same function on the subform with this combo
box as I have on all the others (there are 3 other forms which record data
against the adviser name in other tables without having to select the name
each time) however I just can't get the combo box on this subform to auto
populate (I've tried everything I can think of including copying and pasting
the combo boxes across, and trawled the net for suggestions but still can't
get it to work). Any suggestions would be much appreciated.
Thanks in advance
Dave.