Search results

Hi All, I have a master table with about 40 fields. In addition, I created eight child tables with read only datasheet views of limited fields from the master table. The child table views are based on certain critera in the master table and are being refreshed by using delete and append...

I found the problem. I made changed to the field names in the tables that the forms were using. It appears that some of the name changes did not propogate to the Me.ControlName. Thanks to pbaldy for his assistance.

Here is the db. The code in question is using the OnDblClick property of the frmWorkingJobs form.

JobNumber is the field in the master table and is the Contol Source for form I am trying to open. WorkingJobNo is the field on the WorkingJobs form that I am selecting the record from. I am not sure how to post the db. I have it zipped but don't know how to upload it.

This is the code I am using: Private Sub Form_DblClick(Cancel As Integer) DoCmd.OpenForm "frmVieworEditaCostarJob", , , "JobNumber = " & Me.WorkingJobNo End Sub However, I get a Compile error "Method or data member not found." JobNumber is the name of the master table field that I am...

Thanks for the response. However, I don't understand what the ControlName is in the Me.ControlName.

Hi All, Our company uses an html application in conjunction with SQL called CoStar to house protocols that the Computer Operations department uses to run all of our daily and adhoc production jobs. Because this application does a poor job of reporting, current leads have resorted to various...

Hello All, My name is Tom. I have worked in IT for my entire career. The majority of my experience was with the Milwaukee Journal Sentinel as a Computer Operator. The last three years have been with the Medical College of Wisconsin were I was recently promoted to an Operations lead position...