search another form from a main form

[laidz08]

hi!

I am a newbie here, guys can you help me?? is it possible to search another form from a main form in access using vba? if yes, can you provide me some codes?

please reply. thanks!

[zmbd]

Oh of-course you can use a main form to pull information from a subform. The actual method may vary a bit depending on how the forms are related (or un-related) - in some cases with a parent-child relationship VBA isn't even a requirement.

You should do a search on this site for a ton of threads covering this topic and you should look at Filtering by Form

As for providing code... well, that is not what Bytes is about in that we're not a code writing nor homework service. Instead, if you will provide your work, we can help nudge you in the correct direction.

[laidz08]

I have multiple forms and what i want to happen is that when i search on the main form, a specific form that i input on the text box will appear. I am new to access that's why i find it hard.

[NeoPa]

Being new to Access is fine, and we'll help there where we can, but writing one-sentence posts with very little information in is hardly a result of your Access skills. Unless you can take some time and care over expressing what you actually want (clearly), then we are very restricted in what we can do for you.

Referring to Items on a Sub-Form will give you some ideas as to the structure and terminology of forms and subforms. Z has already provided a link with some other helpful information and explained that we cannot do your work for you from scratch.

If it's worth your time and effort putting together a properly expressed question (that certainly doesn't require any great experience with Access), then we will certainly offer some of ours in order to help.