Search results

I want to make a search command button so that when i click on it, i get prompted to enter a date. I have a database set up and I enter dates of appointment letters when I enter user information. I want to be able to say everybody who has an appointment letter older then "this" date to pop up...

K. Got it to work...thanks a bunch. Jack

Well the form comes up empty....all fields are blank, but I want it to pull up whatever account I have selected in my combo....and yes I have the data field for the "Information" Form set to yes. Hmmm...... Jack

ok...i have the combo box selecting and previewing with this command line...... DoCmd.OpenReport "Account Information", acViewPreview, , "[SubAcct] = " & Me.select now i want another combo box to throw up a form so i can edit the account information i tried this but it kept thowing up a...

OK.... Alright..THANK YOU!!!..I got the form to accept data...my box now selects and it also pulls up the record. My question now is how do I get it so it only prints that record and not the entire data base? Also, how do i get the combo box to update when I add new accounts? jack

OK, I have database setup and everything is working except this last detail. On my switch board I want to be able to select a field and then a report to pop-up according to which "account" i select from the combo-box. Right now i can't get past getting the combo-box to select anything....won't...