Search results for query: *

I need some help to write code in the detail section If rank = 38 then do a page break. Thanks, EVA

nevermind finally got it to work. I didn't create the original form and subform so I didn't notice that the primary key on the subform wasn't set up to equal the one in the main form. Thanks, Eva

I had already tried that but what happens the data in my second table doesn'tget deleted. I am still working on it. Thanks, Eva

I haven't had any answers to my question yet. Hopefully today. Thanks, Eva

Hi, Wow this is my second request today. I need help with the vba code for the command buttons to delete or cancel a record when you have a form with a subform. I am also using a one to many relationship between two tables. Any suggestions, Thanks Eva

Thank you all so much for your help!

the invisible box is not the one I want to set the focus on. It is the store box that is visible.

I wrote this vba code in the after update of a text box. If Me.Dirty Then If IsNull(Me!Store_No) Then MsgBox "Store Number Is Invalid, enter valid store number", vbCritical, "" Me!Store.SetFocus Exit Sub End If End If Store_No...

Thank you so much. It worked!!!! I feel a little stupid. LOL. Live and Learn.

HI, I am hoping to do this in SQL since I already have two subreports on my report and I have to do this to four reports total. I need to do a top 10 for one company, a top 5 for a second company, a top 3 for a third company and a top 2 for a fourth company. Is it possible to do this in SQL...