Search results

I would like to be able to do this: have a text box where users type what they want a list box where the wild card search lists results (clicking results opens the a form on the selected record) and a combo box where you can change the field that you are searching can someone please map it...

if anyone is still confused, do this: deleate whatever preview button you were previously using on your form add a new button that previews the report you want IMMEDIATLY(dont add anything else) right click and go to the build event option, choose code builder that should bring you to the...

missing something in that line of code Neal, you were missing one of these [ in the line of code for the last UniqueIdFieldName it should look like this: DoCmd.OpenReport "yourReportname", acPreview, , "[UniqueIdFieldName]= forms!yourFormName![UniqueIdFieldName]" i tried and tried until i...

thanks marco, that does help a bit

i'm trying to make a form that is used only for search records the record entry forms are done and i wanted to add a form that would allow you to search through to find records

Hi, im really new to access and although i have seen examples of search forms, i have no idea how to make one myself from what i understand, it looks like it is possible to create a list box which looks its values up from a text box on the same form what are the basic steps to creating search...

on a happier note, i fixed the relationship problem anyway but i could still use help on previewing one record (the current one on the form) from a button

i also tried the report button as well (just to clarify this is two different topics, the relationship one is seperate from this) DoCmd.OpenReport "YourReportName", acPreview, , "CaseNum = " & Me.CaseNum i got the error: Method or Data not found did i do something wrong?

that wasnt my problem, but that bit of info does come in handy my initial problem is that one of my subforms does not correspond to the relationships i set for it (i knew i would word it really wierd and confuse people) my main form and other subforms give me the information pertaining to one...

that wasnt my problem, but that bit of info does come in handy my initial problem is that one of my subforms does not correspond to the relationships i set for it (i knew i would word it really wierd and confuse people) my main form and other subforms give me the information pertaining to one...

huh? that didnt get it to work, but maybe i misunderstood what i was soposed to do? i created the report again with a page break in the footer, but it still gave me all the records instead of just the records that corresponded with the case #

ok - i'm gonna try to ask this without confusing everyone - (hopefully someone will understand what it is i'm asking) I am trying to make a report that connects offense codes inputed in one form to corresonding offenses in a table the offense codes are a subform of a larger report the offenses...