Recent content by gcrutch

Is there anyone out there that can help me with this? I'm desperate!!!

I have a form it has several text boxes, fields and a subform. it has a parameter that prompts for a SerialNbr. The fields on the form are SerialNbr, cboCartStatus, CartDate, CartID, ServiceID Subform fields: cboCartEvent, CartID, CartEventSubType, CartEventDate The control source for the form...

here is the code behind the close button: DoCmd.Close acForm, "Add Cart", acSavePrompt yes it is a separate form

yea I did that but unfortunately it did not decrease the size enough.

yes the zip file was too large...

i tried to upload the db but it say's "a security token is missing"

I'm sorry I didn't mean on the actual on Exit event. there is a command button called "Exit" that I put the code behind. but it didn't work.

the listbox is on the mainform. So when I use that code on the other form of the Exit event it's not recognizing the .Requery part

I have a main form with a listbox and a command button for the listbox. When the use clicks the command button (called Carts) a new form opens for the user to enter information that pertains to the Cart. When the user enters the data in the new form and clicks save I need the listbox on the main...

I have a form that has several fields on it and 3 command buttons. I need each the command button to open a new form based on the record that's showing on the main form. can someone please tell me how to go about bringing that record that's showing on the main form to the new form when it opens.

I have a form that have several command buttons one of which is a save record button. ON LOAD 3 of the command buttons are disabled if it is a new record. If it is not a new record the buttons are enabled. Now my problem is this.....The Save Record button is controlled by a macro that is done by...

each form is using a different query. I would love to be able to do something like you have attached but I wouldn't know where to begin to put all the subforms together like that.

Right, I know that to be true. the problem is when I create the query using the appropriate tables, I'm having problems retrieving all of the corresponding data because of the fact that in the beginning there was only one table then the tables were broke up and some of the fields were name...

here are a screen shot of the forms that is associated with the tables. it may make more sense.

that is true GinaWhipp. The other thing is, they had only one table. all the fields were in one table. So when I broke the tables down and normalized them. All of the data is just not syncing back up together.