Search results

In my form, when I select a name from a combobox that is attached to a query it adds it as a new record to my contacts. I am only using the combobox to pull what customer I want from the contacts. What am I doing wrong?

Hi, I am basically creating a "menu" form, where the user can find an existing job to continue to update by selecting it in a combobox. I have created a query with the JobID, Orgname, Location and job closed checkbox. The job will only display if the job is still open. I want the Job form...

I have a combo box in a form. If nothing is selected, I get this error: The Micro Jet databse engine cannot find a record int the table "TblParts'with key matching field(s) 'Parts'. Is there a way to have the field null, there will be jobs that Parts won't need to be selected.

I am creating a menu that has the option to search for an existing job, then opens a form that has a combobox. When the user selects the job, that form and record pops up. Would this be run by a query?

I don't know what happened. I changed the relationships in my query attached to my form because I was getting a "one to many" error when I selected from a list box. I changed the relationship to go from "ID" to "ID" and now I can't type in the form at all. Help!!

I thought I would post this separately... I would like a button on my form once clicked to delete the record then exit the form. How can I do that?" Thanks again!

"I am trying to use a MsgBox when a button is clicked. The Warning comes up asking "Are you sure you want to Close this Job". If they click yes, then ckTMJobClosed check box is clicked (or 1), if they click no, then the check box is left uncheck (or 0). Once they select the form then closes...