I'm quite new to this game: apologies in advanced if this seems an easy/stupid/elementary question!
Access 2000:
I've got a form [accred_edits] which is 'data entry' and sits on top of a table [accred]. There is a combobox on this form which pulls in a list of 'accreditations'. I've already built buttons to allow me to 'add' and 'delete' records via the combo box on the form.
I want to add the functionality to allow me to 'edit' a record I select in the combo box (note - there are no record selectors). I've tried to add a button to open another form which uses the 'current record' ([Forms]![accred_edits]![Combo7]) in the combo box on the original form to open the second form on the specified record - but as it is bound to the combo box - it won't allow me to change the record!?
Any help gratefully appreciated!
Access 2000:
I've got a form [accred_edits] which is 'data entry' and sits on top of a table [accred]. There is a combobox on this form which pulls in a list of 'accreditations'. I've already built buttons to allow me to 'add' and 'delete' records via the combo box on the form.
I want to add the functionality to allow me to 'edit' a record I select in the combo box (note - there are no record selectors). I've tried to add a button to open another form which uses the 'current record' ([Forms]![accred_edits]![Combo7]) in the combo box on the original form to open the second form on the specified record - but as it is bound to the combo box - it won't allow me to change the record!?
Any help gratefully appreciated!
