Recent content by Monstermechanic

I am attempting to generate a report. When building the query I was hoping to add a drop down list to the criteria window. Is this possible?

I currently have a database which has been created to have a user interface which is seperate from the data. On the user interface is it possible to have a password on a button function. In otherwords when I activate one of the buttons I wish to have the user enter a password before the button...

Was on Vacation. It worked. Thank you so much. Now I just have to re-grow my har back.

Have not worked with VBA very much. The form name is VSM - Vendor Surveillance Discrepancy The sub form is located in Child14 The subform name is VSM - Vendor Surveillance Findings The datafield is Test29. This is what I came up with and I just can't figure this one...

Have not worked with VBA very much. The form name is VSM - Vendor Surveillance Discrepancy The sub form is located in Child14 The subform name is VSM - Vendor Surveillance Findings The datafield is Test29. This is what I came up with and I just can't figure this one...

Having issues with auto population in a subform using a subform button control. The code obviously works when in form mode but when as a subform object form cannot be found. Private Sub Command13_Click() [Forms]![VSM - Vendor Surveillance Findings]![Text29] = ("Transferred item to a VCAR for...

Took out [text] and a miracle happened. Thank you.

Sorry, Next to last line. [Forms]![General Report & Incident Page]![CAR Due Date in CAR Tab].[Text] = due

Need some help if possible, Thanks Working on a Database where a "Request Date" is entered. then based on a Drop Down "Catagory" of I-IV a "Due Date" is to be autimatically generated and populate the "Due Date" field. Below is the code, however I'm receiving a Runtime Error 424 Object Missing...

It prints out the main form,,,,

Already attempted this...

Could anyone give some assist on how to print only the subform in a form. I'm looking to create a print preview command button that will allow only the sub form to be printed... Thanks for the assist.....

Thanks for your assist. This works great. Unfortunately I did not have the full versions of VBA on this "work" computer. Thanks again for the assist......

Been there done that and have an XXL teeshirt.

Redirect your Data fields in the form properties I believe You will have to open up the properties of the 2nd form and on each of the Fields that you are entering data into you will go to the Data tab. you will then have to change the Record Source for that field. Hope this helps...