Search results

I've tried that also but still gives complie error message

I tried that and I've attached the error

Yes it has been saved, actually I already have 3 records on the first form.

I tried this DoCmd.OpenForm "frmVehicleMaintenance", , , "txtbox_VehicleId" = " & [Forms]![frmInventoryMain]![txtborx_VehicleId] &" '" and this 'DoCmd.OpenForm "frmVehicleMaintenance", , , "VehicleId" = " & me.txtborx_VehicleId " The 2nd form now shows up but there is no data. Any...

If I use this 1. DoCmd.OpenForm "frmVehicleMaintenance", , , "txtbox_VehicleId" = " & [Forms]![frmInventoryMain]![txtborx_VehicleId] &" '" or this 2. DoCmd.OpenForm "frmVehicleMaintenance", , , "VehicleId" = " & me.txtborx_VehicleId " The 2nd form shows up but with out the data.

When I tried that I get Run-time error '2465': Microsoft Office Access can't find the field 'frmInventoryMain' referred to in your expression.

Private Sub btnVehicleMaintenance_Click() DoCmd.OpenForm "frmVehicleMaintenance", , , "txtbox_VehicleId = '" & [Form]![frmInventoryMain].[txtbox_VehicleId] & "'" End Sub This is all that's on the event procedure

How do I check if it's still open :) (not sure how)

Well just thought maybe that is what's causing my error when I tried your suggestion. I tried playing around now I think I am on the right track, the only problem is "Enter Parameter Value" box display and when I type in the Vehicle Id. the record displays. What I want is once I click on the...

Thanks for you response ruralguy. but how do i do it if it is on a tab page?

Hello, I have 2 forms, both are data entry forms only a few minor difference. What I want is to have the data on the 1st form display on the 2nd form (not necessarily all the data). The 2nd form is opened once I click on a button. When it is clicked I would like to display the current...

Thank you very much. that works

How do I make my form follow the size I want? It's in access 2007

I saw what was wrong. I inadvertently put a code to have it loop around. Took the code off and it works fine now. Thank you

I did that. I think I know where I went wrong. I'll try that again and delete an event. keep you posted. Thank you.

I created an exit button. I want to close everything (database, forms, query, macro). But the codes I put in it just doesn't work. How do I do this? thank you.

Thank you very much for you patience I now this has been a very long thread hopefully it would be done soon. Max D, Thank you very much but I am only using access 2003 HiTechCoach, My add form is a single form. Why do I get "Microsoft Office Access can't open the file...

hello again, looking at it it works fine and I was able to incorporate it on my database. Is there a way when I try to pull up a picture it will instantly show the image and no need to click view. only for images.

hello, I will try to incorporate this on my form. Thank you very much HiTechCoach, you're really Hi Tech!

Thank you very much. I will be waiting.....