Search results

You are a lifesaver. Thank you so much, it works perfectly. And yes I am using the form for data entry also so I added a bound text box and it works great. Thanks again!

I apologize for asking yet another question about autolookup but I have poured of Pat Hartman's example and all the posts in this forum and still can't seem to make it work. I have attached my db. I want to type in the asset number and autofill the rest of the form. Can someone please look at...

Thanks for the insight. I used a subform and it seems to be working. Don't know if there are any performance hits associated with doing it this way but after hours of fighting with this I'm just happy it is finally doing what I want! (SID by the way is Student ID)

I'm sorry, I'm confused. I tried that but it did not work. I'm not sure I would want an update query since my goal isn't to update the table. My main goal is to verify that the SID number exists in this seperate, large table. At this point I just want the name displayed on the form (not saved to...

Help! On my form, when users enter an SID, I want to first verify that the SID exists in another table (tblSISAR) and second, to fill in the name (from tblSISAR) associated with that SID. tblSISAR has 25,000-40,000 records in it so I don't think a combo box is feasible. I've tried dlookup in...

Thanks a ton! I have looked at it a hundred times and didn't notice that!

I am having trouble with filtering a report by date. Users that select 'run daily report' are then promted for start and end dates. My problem is that once dates are entered, the 'Enter Parameter Value' box pops up. If you click ok, the report runs and filters properly. I've used a query as the...

This should be very simple but I can't seem to figure it out. I have a startup form in which I have 2 comboboxes. I want the user to select a choice from each box and then pass those choices to the next form which is a data entry form. Users will be inputting several records but those two...

You're right about the null. My test data did not have any nulls but that would have been a problem. I inserted breakpoints in the code and watched it go through all records. Also the count field shows the correct number of records. And I just realized what my problem is....I had originally...

I am trying to loop through a recordset and update a currently empty field in a table with something depending on another field. After hours of frustration I can't seem to get it to figure out what I am doing wrong. Only the first record is updated though I know it is cycling through all the...