Search Records

[desibabu90]

I want to create a Form with just one button that a user would click and then ask to enter a "Unit No". This would then open a form named "Final" and search for the record with that "Unit No".



Any help would be greatly appreciated!

Thanks in advance

[orange]

see http://www.datapigtechnologies.com/f...earchform.html

[desibabu90]

hey this doesn't really help because it is about creating a query...i want to open a form and find a record...

[orange]

hey this doesn't really help because it is about creating a query...i want to open a form and find a record...

I suggest you watch the entire video again. And if you still don't understand the importance of the MainQuery and the search form, then tell us the part that is particularly complex or confusing. If, however, in the meantime, you find a way to do this without a query, please post the solution so we can all benefit.

Good luck with your project.

[desibabu90]

I suggest you watch the entire video again. And if you still don't understand the importance of the MainQuery and the search form, then tell us the part that is particularly complex or confusing. If, however, in the meantime, you find a way to do this without a query, please post the solution so we can all benefit.

Good luck with your project.

i did watch the whole video..the reason why I cannot use a query is because on the form I have fields where I am going to need the user to enter data that will be recorded in a separate table. I saw the code for opening the query which I can use to open the Form but then how do I code the search for a record...

[orange]

I want to create a Form with just one button that a user would click and then ask to enter a "Unit No". This would then open a form named "Final" and search for the record with that "Unit No".

Any help would be greatly appreciated!

Thanks in advance

Seems like you need a method to get the Unit No from the User.
Could be a form with a text box or combobox, could be a msgbox/inputbox. Then use the data they have entered
in a DoCmd.OpenForm "Final" with an OpenArgs parameter.

There is an example at
http://office.microsoft.com/en-us/ac...001232773.aspx

If you use a form with a combobox for UnitNo and let user select one, then this video may be of use
http://www.datapigtechnologies.com/f...tomfilter.html

[desibabu90]

Seems like you need a method to get the Unit No from the User.
Could be a form with a text box or combobox, could be a msgbox/inputbox. Then use the data they have entered
in a DoCmd.OpenForm "Final" with an OpenArgs parameter.

There is an example at
http://office.microsoft.com/en-us/ac...001232773.aspx

If you use a form with a combobox for UnitNo and let user select one, then this video may be of use
http://www.datapigtechnologies.com/f...tomfilter.html

ok thanks..i will look into this and report back..

[desibabu90]

if anyone wants to know how to solve this..i got it from here:

http://bytes.com/topic/access/answer...ate-new-record

you do have to use the openagrs parameters