Search results

Hey Paul and txboy, I am trying to do this too. I have a field right now that the user just types in the hours himself. It is bound to a table field. Do I put this formula in the format of the form field? I tried and nothing happened. Can you talk me through it?

Perfect....thank you thank you!!

I'm sorry. I used the combobox wizard and when I pulled down the combobox, it only showed the dummy jobs I had created to test, not the actual contacts in the contact database. Plus the afterupdate was there before as we do not want the tech to be able to change the org name after he selects...

Awesome!! While on the subject of it going to a new record. How can I have it go to a new record when it is opened by my switchboard button "new job", but not go to a new record with this search? Is that possible?

Still didn't work, now getting that the form is misspelled...hmm.... I attached the db the form the combobox is in is the FrmExistingJob

Thank you! Unfortunetly, when I do this, the name I select isn't store in the query the form is based on. (I had to use a table for the value because it is searching the field not the query). I have attached my db, it is the FrmTime&Materials form.

Sorry, it is: Private Sub CmbExistingJob_AfterUpdate() DoCmd.OpenForm "FrmTime&Materials", , , "JobID = " & Me.CmbExistingJob End Sub

I am sorry Paul for being a pain, but I did realize it was a numeric field. I removed the single quotes but still not working. Now getting a Run time 3075 error: Private Sub CmbExistingJob_AfterUpdate() DoCmd.OpenForm "FrmTime&Materials", , , "JobID = " & Me.CmbExistingJob & "" End Sub I...

Ok I changed that and now have: Private Sub CmbExistingJob_AfterUpdate() DoCmd.OpenForm "FrmTime&Materials", , , "JobID = '" & Me.CmbExistingJob & " '" End Sub And now get a runtime error of '2501'

When I unbound the combobox, I can no longer select anything in any of my comboboxes now....?????

Thanks! How do I filter the recordset?

I am getting a pop-up box asking for the parameter value of "TxtTMJobID" Here is my code: Private Sub CmbExistingJob_AfterUpdate() DoCmd.OpenForm "FrmTime&Materials", , , "TxtTMJobID = '" & Me.CmbExistingJob & " '" End Sub Suggestions?

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?

My problem database :-0 I am having major Relationship issues.

Oh, never mind, I got it. Thanks for your help!!!

I wanted to refresh this.

Now I can type inthe form, but can't select anything in any of my list boxes. ????