Mary,
Thanks for the reply and suggestion. I didn't put the Requery in the Form_Current function originally because I thought it would only work when the record was active. In fact, that is the case. Your solution works fine for Single Form, but I was trying to get the List to populate differently for each record in Continuous Forms mode. Unfortunately, your solution doesn't do this. You still need to activate each record to show...
tombarth11
Last Activity: Apr 30 '09, 08:31 PM
Joined: Feb 26 '08
Location: Cincinnati
-
-
List Box contents not changing for new records
I have searched, but can't find a thread that addresses this problem. I think I'm just overlooking something simple, but I'm stumped at this time. My problem is that I need to provide a list of order numbers that are associated with a piece of equipment. I have a Form (frmEquipment) that is bound to a table (tblEquipment). I have another table (tblOrderNumber s) that contains, among other things, a Foreign Key field (called EqptKey) to tblEquipment... -
Thanks, Stewart for the info. I tried it with an expert friend and it didn't work, but it did help lead us to the eventual solution. Apparently, the user with whom I compared references was mistaken when she read one of them to me and it turned out that the missing reference had date and format functions that were superceding the Visual Basic ones. Once I removed the reference, the user was able to see the data. Thanks again....Leave a comment:
-
Ouch! I had seen that comment and checked with one of my users, who is in the same building. She had the same references as my machine. I have users all over the country, so it is difficult to check everyone out individually. Besides, they are all copying an mde file and the references are grayed out for mde files. I would rather not expose my design and code to the users if possible. That is why I chose to go the mde route in the first place. Is...Leave a comment:
-
Format and date functions not working for users
I have an Access 2003 SP2 Application in which I split the data base into 2 files: data-only.mdb and interface.mdb. I then "compiled" the interface file to a .mde file. Both files are on a server. The data-only file stays there permanently, but I have the Users copy the interface file to their PC and use it locally. My problem is that I have a number of queries that use the Format() and date() functions. I have no problem executing them,...
No activity results to display
Leave a comment: