Form population via button

[DAyotte]

Ok, I did a brief search through the forum (flame me if necessary), and although I did find something similar to what I'm looking for... it's not exactly what I need.

Using Access 07, I've put together a table of data with about... 7400 records - each one has a specific ID number.

I've then designed a form with all text boxes bound to the various columns of data. I want the user to be able to type in the ID they are requesting, hit the search button and BOOM, all the info is there. Everything I'm coming across is saying to use combo boxes, but with as many records as I have... that wouldn't be a viable option.

Please Assist.

 

[DAyotte]

yes, I have the combo box in the header. You can search, or type the store number in there and hit enter. This will populate the 21 fields in the form with all the corresponding information. Address, City, State, District Manager and their contact information, etc.

Being that we have so many stores, I thought that this way was going to be the simplest for the person using it All they will have to do is bring up the form, and type in the search request to obtain any and all info they would need for that particular store. There are certain steps that we have to do differently in resolving our issues with the store if they were acquired through a merge or buyout, and I was hoping to be able to show that too. My assumption was a check box would be the easiest way to do that.

 

[DAyotte]

With that being said... the database I've created for this has only this Form, and the related Table that it's pulling all of it's info from. I don't have any Queries in it, because I haven't needed them yet.

 

[Norie]

I think I'm missing something here, that sounds like there is no data in the form to start with?

Am I wrong?

Anyway, the way I see a continuous form is that you can list all the records with certain fields so the user can identify each or see a 'summary' of the record.

eg store name, current status, address etc

Once they've identified the store they are interested in the click a button (each record will have one) that opens another form.

This form will have all the data for the store the user had selected and this is where they can alter it or just view it.

Does that make sense?

I would post an example form but I have no data to work with.

 

[DAyotte]

You are correct in that the form has no data when it's opened. Say I'm working on store 326. I open the form, and type "326" in the combo box and hit enter, or click out, or whatever, and the form populates all of it's fields with the information on 326.

I can't remember how to post pics in a forum... is it just the url of the picture on a shared site, ie: photobucket?

 

[DAyotte]

The user will always have the store number. That's all that it should take to identify the store. That's why for ease of use, this is all that they need to punch in.

 

[Norie]

Have you tried creating a form based on a table?

All you need to do is select the table, then goto the Create tab and press Form.

Access should now have created a form for you.

It probably won't be pretty but there's nothing stopping you changing it.

Also a standard form has a navigation bar where the user can navigate between records.

There's actually a search box on that, but I've never used it so don't know what it does exactly.

If you want to create a continuous form it's pretty straightforward too.

Select the table again, goto the Create tab and from the More Forms dropdown select Multiple Items.

 

[DAyotte]

no no... sorry, I think i'm confusing myself. This form is based on a table.

 

[Norie]

Can you post some data?

Nothing confidential, just a few records with something representative of what you actually have.

 

[DAyotte]

I'll do my best. Hang on...

 

[DAyotte]