Search Form

[NotVeryTechie]

Hi there

I have tried searching this forum, but I must be searching on the wrong words or something and I can't find what I am looking for. I would like to have my main form open without any records showing, and then the user can type in information in one of the fields and click on search. The record searched for will then come up and can be edited. I suppose the easiest way to do this will be to have a button on the main switchboard that says 'Edit Record'. And to have another button that says 'Add Record' which opens the normal form, but at a new record. Or can these be combined?

The problem is that I can't work out how to do this. I tried making a new form, but then couldn't get it set up so that the records could be edited.

Hope you can help

 

[dsigner1]

The usual way to achieve what I think you are looking for is to use a combo box in the form header. if you create it with the wizard it will ask you if you want it to find a record. This will mean your form comes up with some records showing but so what. Once the user has used the combo box the form will be displaying what he wants.

 

[NotVeryTechie]

Hi there

I put the combo in the header and I can look up a value from the list, but it doesn't have any effect on the form. It still stays on the record that it opened on.

Also, I have an input mask in the table on this search field. In the lookup box, the formatting from the input mask has disappeared.

What am I doing wrong?

 

[dsigner1]

Not sure - it should go to the record if that is what you asked the wizard to do. Is the form a standard Access form or have you set up your own record source? Try creating the form from a query, then add the combo box. This definitely works

 

[NotVeryTechie]

I created the form using the wizard initially and then made a number of changes to it. So the form is all set up. Do i need to create a new form to use for editing and searching?

Can I search on more than one field - I mean, search on this field, or that field, or that field, not lots of fields at once?

 

[dsigner1]

Just create another test form using a query and get that working with a combo box. Once you have got the idea you can introduce changes and see where the other form fell down. i would not play with your "good" form till you know what is going on

Easiest way to do different fields is to you a different combo box for each. once you can get the first working you will have no problem