newbie question here---
In Table1 I have basic membership information. Table 2 is 'event'
information. I have a form for Table2 with a combo box, where the user
will pick a member from Table1, and then fill in the rest of the data.
My question is this - I fear the combo box will be used incorrectly -
that is, they will use it to 'find' a record. Click on the drop down
box and make a selection. However doing that of course does not find a
record, it changes the current record. I was thinking I need some kind
of lock on that field that is in place after the user clicks a button
or something. If the record needs to be changed, they would have to go
eslewhere to ensure they know they are changing the record.
I'm sure many people have run into this before. If you could tell me
what you do to solve it, it would appreciate it. p.s. I do not know
VBA, if the only solution is in VBA you will need to walk me through
it step by step.Thank you.