Update Table with Combo Box

[bstboy]

So I have a table in the format (I tried to DL HTML maker but it's asking for a password)

Month Brand 30 Day 60 Day
Jan A 20 40
Feb A 25 42
Mar A 15 59
.
.
Jan B 30 60
Feb B 15 92
Mar B 35 99
.
.

I'd like to create a form in which a combo box would allow you to choose the brand (I already have a master table with all brands), then beneath that only the 30 and 60 day values for each month for only that chosen brand are visible for manipulation/changing. In short, I'd like to change the data directly in the table using a form but I only want to see the chosen brand's data. I would expect to have 24 boxes in which I can change (12 months x 2 metrics, or in other words Jan 30 Day, Jan 60 Day, Feb 30 Day, Feb 60 Day, etc.)

Not sure if I need to create a subform here or not. I've tried several things and they're not working...obvious novice here.

Thanks for the help

 

[Joe4]

I think part of the problem is that your data does not appear to be normalized (see data normalization rules here: http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx). If it was, I think you would find your data easier to work with.

Once normalized, the data table would look something like this:

Month  Brand    Day   Value
Jan      A       30      20 
Jan      A       60      40
Feb      A       30      25 
Feb      A       60      42
Mar      A       30      15
Mar      A       60      59
.
.
Jan      B       30      30
Jan      B       60      60
Feb      B       30      15 
Feb      B       60      92
Mar      B       30      35
Mar      B       60      99

 

[bstboy]

Thanks but still having trouble

I'd want the form that will change the table to look something like

Month___________30 Day__________60 Day
Jan______________20_______________45
Feb______________25_______________40
Mar______________15_______________60
.
.
Dec

Where the values are basically text boxes in which I can overwrite the value and it automatically overwrites the value in the table of origin. What I'm getting stuck with is that the combo box will need to call multiple records into the form (and not just one record).

 

[Joe4]

If you create a parameter query (based on your table) where the user is prompted for whatever criteria you want them to enter to select the appropriate records, and then base your form on this query, that should do all that (you should have an editable form when they can select the records they want to update and then update them).

 

[bstboy]

GOT IT!!

Thanks so much for your help