| |
You are here: Experts > Computing/Technology > Business Software > Using MS Access > Records in form
Expert: Scottgem
Date: 9/5/2008
Subject: Records in form
Question
I have a table called TableConference and in form, I have created a form. In the form, the fields reference to the TableConference data. I have about 300 records now and some are the same name conferences that occur on different dates. In the form, I have a drop down menu for the conferences...where someone can choose the conference. Here is the problem I am running into. Sometimes when I type in the conference or choose from the drop down menu (combo list box), the conference title change but my other info (other field like day, date, time, location), stay the same. If there a way where I could avoid this problem in the future because other people will be using this form and different people means different working ethnics. I want to avoid these mishaps as much as possible. I hope I am being clear, if I'm not, please let me know what I could do to clarify. Thank you.
Answer
It sounds like you are editing an existing record instead of creating a new one. I generally use different forms for adding new records and editing existing ones to prevent that from happening. Or I require the user to press a button allowing editing before they can change any data,
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: MS Office Access 2007 VBA
Add to this Answer
Ask a Question
|
|
