Search results

it's another form. I have the main form open (although I'd rather not)

As usual, I'm not getting it. What should the code behind the After update looklike. I've only got Me.Requery right now and I'm sure that's not right.

A few questions. First: will this work if my search form is separate from my main form and the main form isn't open? Second: Please explain All records on form open and an An AND search on any criteria entered. Third: Can this work with a search button rather than prompting? Fourth: Is...

code I see what you're saying, but if one of the cirteria is left blank, all of the records are displayed. I've been working on some code (whith much help from this site) and I'm pretty close. It works if I enter the first name, but a prompt pops up. The prompt has the last name that I just...

Yes, for some of the fields I plan on using combo boxes. But for a field such as Height, I think a text box might be better. I've decided to scrap the checkboxes as I'm sure from what I've been reading, a NotNull might work (although I don't know how) This may be a bit over my head.

aahh, so simple. Thanks.

Can anyone help me with (or point me to an example) creating a search page with unbound textboxs. What I need to be able to do is select a checkbox to include or not to include the textbox in the search. For example: I have physical descriptors in my table such as "Race", "Age", ect. I need...

I have a textbox sized to 4 lines of text on the screen. How do I limit the textbox to only allow those 4 lines to be entered? The problem I'm having is that once the 4 lines are filled, the box continues to allow data to be entered. It is not allowed to shrink or grow and enter is used to go...

I know you've got to be getting tired of this by now. I completed the report using a subreport for the charges. Everything seemed to be working, but when I tested it I'm back to the same problem as before. I've defined the Master/Child field but it's displaying all of the subreports for the...

Well geocities is a little slow (I guess what can I expect for free?) I've ended up just redesigning the db that you helped my with earlier to fix my needs. I still don't know why this one works and not my main one. I can't begin to thank you enough for all your help. I wish there was some...

I have to repost with the changes.

right, that works. But I need to limit the report to show only the current form and subform. Right now it shows the current form, but all of the "subrecords" associated with that subform are also shown. My actual dbase doesn't have the car info. I was only using that at home for an example...

I removed all of the cirteria in the query. I also changed the column ChargeID to Booking Sheet number (using the Charges table). I have the following behind the command button: DoCmd.OpenReport stDocName, acPreview, , "[Booking Sheet Number]=" & Forms![BookingSheet]![ID] & " AND...

I've almost got it working but it's showing all of the subform records again rather than the current one.

Great! Now that I'm at work I've been trying to get it to work on the real dbase. It worked fine at home on my example but I can't take what you explained and apply it to this one. I need to do the same thing based on the [ChargeID] field for the Charges subform. I know it has something to...

I think it's close, but now it's prompting for [ID]. http://geocities.com/philpoole16 if you make the changes and want to post it to the site, my geocities user name is philpoole16 and password is 123456. Thanks again.

Sorry about that. I had to change the filename. Thanks again. I've compacted and ziped. Still too large. ????? The above link should work now.

Ok, I'm sure it's just my inexperience or hard head, but after three weeks I'm still not getting it. I have no doubt your solutions will work...just not for me. I've posted my dbase at the link below. I know it's a mess. Since I don't have the latest version of it here at home, I just made a...

I'm on my way to work. I'll give it a try when I get there. Thanks.

Wayne, I must admit I'm still working on the problem that I had a couple of weeks ago that you helped me with. My lack of experience and my hard head are realling making this impossible. I'm still trying to get a repot that displays the data in the current form and subform. I've gotten it to...