Recent content by LISAANN

This works perfectly, thank you so much for your help!

Purely display as the information being stored will already have been entered by the database manager.

I have a form field labled "Display/Print Name", I would like this field to contain either the first and last name of the client or the company name if the aforementioned is null. How would I go about this? Thank you for your help! Lisa

The reasoning behind this button is to delete a record from the "active" table and then archive it to "deleted" table. The reason I need a pop up form is so the user can explain why they will be deleting the record. The users of this database are not very accurate and delete...

I would like to have a commnad button that selects, copies and saves a record from the current form and then open a new form and place the record there. Upon closing the new form I would like the record from the current form to be deleted. I have played around with the following code, but cannot...

I think that my confusion lies in the following: DoCmd.OpenForm "frm2Name", , , , acFormAdd, acDialog, "value" (VALUE=FIELD FROM FORM1? EX. COMPANY NAME, COMPANYID?) Me.MatchingField = Me.OpenArgs (MATCHING FIELD = "VALUE" FROM FORM 1?) If this is incorrect...

Thank you so much for all of your help! It works fantastic, except for I still cannot get the new form to come up with the matching company from form 1. It is really no big deal, and eventually i will figure it out I am sure. Again, thank you so much!! Lisa

My error is "2501" Run Command Action was cancelled.

Thank you very much for taking the time to help me out. However, I am having a few problemas. I need form #2 to open with a new record and the matching field from form #1. I also get a run time error when "no" is the response for deleting a record. If you could help me with these two...

I would like to create a command button that takes my user from form #1 to Form #2 to enter information. When Form #2 is closed I would like to have the current record in Form #1 deleted. Is it possible to do this? Lisa

Thank you so much for your help. The double quotes worked like a charm! Thanks again! Lisa

I have set up a look-up field in my form that gives me the error message;(missing operator)in expression; whenever I try to pull up anything with an apostrophe. What the heck is up with that? I have pasted the code below, please, someone, tell me what I am missing.Thank you, thank you, and many...