Recent content by kmeulemans

Never mind. Got it working

I have one more quick question. On those Combo boxes from yesterday, you can select and see the machine names, but it only dumps the ID number into the data collection table. What do you need to do to get it to dump the machine name as well?

Bob, You are the man! Thank you. I see what you changed. If there is ever anything i can do to help you out let me know... (i'm a Mechanical Engineer, so prints or calculations or something in that vein)....

I have the Data base now uploaded... If you could take a look at it, I would really appreciate it

I would love to upload my Database...(it is 2003) its like 10 times to big...

I've got a Me.requery event in the after update... Private Sub CategoryAfterUpdate() Me.Product = Null Me.Product.Requery Me.Product = Me.Product.ItemData(0) End Sub

They are both bound to a table. They both pull info from Machine Table and then dump the selections into tblOpen...

All, I am having problems with my Combo box "remembering" what values were selected. I have a cascading set of combo boxes where a user selects the area in the first combo box and then in the 2nd combo box the user can select the options that correspond the to options selected in the first...

Sorry it took me so long to post another reply. I have tired to upload the screen shot again....Maybe it will work. The little buttons toggle back forth between the 2 forms. I need the form "B" to open to the same "Number"

No, those are not the "real" field names. My question is, how are the fields even relevent? I have 3 different fields in Form "B" and Several in form "A" See the screen Shot.

I am missing something. This is what i put in on the Click event. Its saying there is a bug.. Private Sub Close_Work_Order_Click() ' first save the record IF there are changes If Me.Dirty Then Me.Dirty = False DoCmd.OpenForm "frmClosed", acNormal, , "[RecordIDFieldName]=" & Me!RecordFieldName...

One More dumb question...where in the button code would i paste that code you provided?

Thanks for the Welcome! I'm sure i will be using the forums frequently as i have 2 databases already to build and probably more in the works. Would that code be any different since the data in form B is going to a different table?

All, I am in the process of creating a maintenance database. I have created a form "A" has an area for entering the work required. I have a second form "B" that is linked to form "A" with a button for entering the work completed. How do i get the second form to open to the same Record number as...