Looking up / Searching for a record in a form (to be displayed in another form)

[Missionary2008]

I have a database for sponsorship. I use a form "frmSpnosorInformation" in which I have other forms embedded for the user to enter and change data.

I also have a dashboard form "frmDashboard" that is open upon opening the database.

I'd like to create a search button or search field within this dashboard form (frmDashboard") that the user can enter the name or a partial name of a sponsor and be shown the record or records in question - and allow them to see the "frmSponsorInformation".

Thanks in advance from a database newbie.

[NeoPa]

Example Filtering on a Form should give you what you need for that.

[Missionary2008]

NeaPa,

Thanks for the reply. Since I'm new to this I could be entirely wrong. It appears that the Form Control you reference will allow me to find a record and display the information on the form that I entered the Account Code, Creation Date, or Account Type.

Is it possible to, after entering the information we are searching for and hitting enter - that we can have the form (with sub forms) that we use to enter date come up?

[NeoPa]

Yes indeed. That was why the [CreationDate] was included in the example. The article includes the code and the instructions for how to handle filtering by a date value selected in another control.

[Missionary2008]

NeoPa,

I've been trying to figure out the code with little luck. I just keep getting errors. I'm extremely green when it comes to code. I've been able to do enough with the utilities built into Access 2007. Is there a way for me to do so using those and not code?

I have another project in which instead of a name to look up and I will need to look up a check number so I'd really like to learn how to make this happen within a database. Thanks in advance!

Very Slow,

Missionary2008

[NeoPa]

I'm not sure what you're referring to with the term 'utilities', but I can't think of anything that would give this functionality. You could try looking at the Form Wizards to see if one fits the bill, but don't be too disappointed if you find nothing there to help.

As for further help, that will be difficult without a clear idea of what you're hung up on. I appreciate you're out of your depth, but the article explains it as well as I can in general terms. If I'm to help with any particular problem with understanding that I would need an understanding of what that problem is. That's why just saying you can't do it won't help me to help you. I'm sure I can lead you through it at pretty well whatever level, but I'd need to know what level to pitch it to do that.

That's why we suggest/insist members post what they have managed to do and report the problems they're struggling over.