Field List

[ZimSuda]

Can someone help me overcome an obstacle I'm having.&nbsp;&nbsp;We've setup an Access 97 database to replace a Mac File Maker Pro system.&nbsp;&nbsp;We've imported all of the tables, etc. into the database and now the users are asking for enhancements.&nbsp;&nbsp;They'd like drop down lists to chose from for various fields.&nbsp;&nbsp;My concern is that when I set up a combo box, etc. that the data previously entered into that field on a record doesn't show...it will let me select one of the choices off the list and stores it, but the previously entered data isn't displayed.&nbsp;&nbsp;They may need to change the previously entered data from time to time as well as add for new records.&nbsp;&nbsp;Please let me know if there is an easy way to do this.<br><br>Thanks!

 

[DougP]

try this to refresh teh combo box<br>combo1.requery <br>where combo1 is the name of your combo box<br>do this after you enter new data<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[Guest_imported]

I believe the form may be in data entry mode or you do not have the combo box properly bound to your field.<br>if you right click on the form and click remove filter it should show all the records for that form.<br>good luck