Recent content by hassanmfsa

Try this: when you SELECT Field1 for example try to use the following for each of the fields you're selecting. SELECT NZ(FIELD1,VALUE) Field1 is the field that is null. Value is the value you want to put instead of Null. Value must be of the same type of Field1. Regards, Hassan

For Mattborn, You need to leave the form open while opening the query.. Thank you.

To complete what Mr. Michael said, when copy the text fields or any control field do not forget to change the control source for each field if it does not give the required value. Thank you.. Hassan

Hi, Try this, 1. Create a textbox where you want the value to be duplicated. 2. Go to the properies of the textbox. Then: Press Data tab. 3. Notice the "Control Source". Press the side button "..." 4. Choose the Forms category.. Loaded Forms....Then the form that is open...

Actually, I think it means that you have no records at all to explore. So, either you you write in the table itself some records, or: You add a record through the form you have created. Just write the record and save it through the save button. Or: put a save button on the form itself: 1...