Search results

For just one entry, i would suggest using a Dlookup as the default value of the textbox. Then refresh the textbox in the afterupdate event of the dropdown box. DLookup("CurrentFXRate", "tblCountry", "cbCountryName = " & Forms![yourform]!yourlistbox) This will give an error if your default...

Hi All, I have a List Box Dbl Click Event, which takes the value of the list box and opens a new form with a records values. It works perfectly, for me. I had a user try it and nothing happened at all, not even an error prompt. How can it work for me and not the user? It's just one user...

Ok so the end result! 44 dlookups removed, and values copied from recordset in place...time to load....INSTANT. Pretty damn good, i was not expecting these results. Previous time, between 10-12 seconds. :D

This is exactly what i was leaning towards. I used this code to accomplish it (in form open event): Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("EmpEditQ") rs.MoveFirst Me.FirstName = rs!FirstName 'etc, etc 50x rs.Close I'll post back when...

Yes, i've tried and i have several problems with using the query as the recordsource: 1. Its a 4-layer sql query preventing any edits in the textboxes. 2. Even if i could edit, it would have to be bound (im assuming), eliminating my copying of the record without messing up the original record.

Thanks again, but im failing to either communicate my objective, or comprehend your answer, so I'll rephrase: The objective is to load a selected employee's most recent profile, into textbox's on a form, then allow user to update these textboxes, and click the "Save" button to make a copy of...

Thanks for your reply. We agree, dlookups should be used sparingly, I just dont know what else to use. Perhaps you can clarify your combo-box suggestion. Aren't combo boxes used for drop down selections? I'm not sure where this fits in with my question.

Hi Everyone, I have a form that has about 50 dlookups to a query that narrows all records of my main table, down to one record. Needless to say, this form takes 10-15 seconds to load. I've used dlookups because i want to load the data in the numerous text box fields, to allow the user to...