Auto Populate Form Controls from Form List Box selection

[alexk15102]

I am a very green Access user and am trying to create a database for tracking a plastic miniatures collection. I have already looked through the forums and frankly the responses to similar topics have been above my head. Feel free to address me like a child.

The structure I have is two tables. Table one is titled SetNames, table two is titled Miniatures. SetNames contains three fields, SetName, SetTotal and an attachment (jpeg) SetSymbol. Miniatures is for holding records on each individual model.

On the form SetNames is a list box control, and when a set name is selected I want the SetTotal and SetSymbol controls to auto-populate with the data from the same record of the SetNames table as the SetName.

Any help would be greatly appreciated.

 

[alexk15102]

Nothing yet?

Bump.

 

[missinglinq]

Why not simply let Access do all the work? You may have done some of this already.

Create a form using your table/query as the Record Source.
Goto the Field List and drag the fields you want retrieved onto the form
Place a listbox on the form. When the ListBox Wizard comes up:

Select "Find a record on my form based on the value I've selected..."
Next
Select the appropriate identifying field to appear in the Listbox
Next
Size the Listbox column
Next
Name the listbox
Finish

Now the user can click on the listbox to retrieve the data.

 

[alexk15102]

Thank you for your response, but I think you misunderstood my request. I have a list box control on the form already pulling the list from a column in the SetNames table, and storing the selected value in the SetName field for each record in the Miniatures table. That much was easy. What I am now trying to accomplish is this; when a set name is selcted in the existing list box control I want a SetTotal control, and a SetSymbol control to pull data from the same record of the SetNames table and display them on the form. SetTotal is a number representing the total number of models in the set, and SetSymbol is an attachment in the form of a jpeg image that I want displayed. Each control should display data from the same record as the selected SetName from the list box.

 

[missinglinq]

I'm sorry, I don't know how to make this any more simple. The directions I gave you do exactly what you've requested.

 

[alexk15102]

That's alright. It is entirely possible that I am being dense. Does this mean I have to remove the list box control I already created, add the controls for the other two values, and then recreate the list box as you have explained? I'll give it a try on a copy of the database.

Thanks again.

 

[missinglinq]

Remove the listbox you already have.

Assuming your form is based on the table SetNames, using the directions I gave you, create another one on your form based on this same table.

If the SetNumbers and SetSymbol controls on your form are bound to the same fields in the SetNames Table, they can still be used.

 

[alexk15102]

This doesn't appear to be working. I am uploading what I have on the Form Design screen in a jpeg. I want the highlighted controls to auto-populate with values from the SetNames table when a value is selected in the SetName list.

 

[missinglinq]

Sorry you're having trouble with it! Screen shots of a form, even in Design View, are pretty much useless in trouble shooting a problem. You really need to zip up your database and post it for anyone to be able to figure out what's wrong.

 

[alexk15102]

That's not going to work. The db is currently 20MB zipped. File size restrictions here are under 1MB for ZIPs.

 

[spudracer]

Alex,
Copy the db, make the copy a skeleton with one sample entry, then zip and upload that db.