473,320 Members | 1,831 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Combo Box Question

I have a table for all my combox boxes.

ID: AutoNumber
ComboName: text
ComboValue: text with no duplicates

I have create a query based on this table.

I have also created two forms based on this query.

The main form has a combo box with the name
The subform has the field ComboValue which opens in datasheet view

I have the form requery based on change to the combo box and it works
fine.

Problems:

When I delete from the subform, the combo box get the #deleted# message
and I can no no longer change the combo box value until I close and
open the form.

What I've tried so far:

I tried to make the form requery after deletion and also tried requery
in several different places to try and make it work.

I also tried to make the form close and open after a change. and
variations of requery and close/open the form.

Bottom Line: I need help to create a place for the customer to go and
select the drop down name from a combo box and be able to update the
list that shows below.

I know how to create several combo boxes where they can be updated
based on the query, but that I believe is the hard way.

Thanks.

Nov 13 '05 #1
3 1788
Oh, it's also MS Access 2000 that I'm using

Nov 13 '05 #2
And also one problem, but I'm sure it will be corrected with your
solution. If I change the first record in the value list it appears in
the rest of the fields. It only happens with the first record and if I
delete it and change the first record again, it does the same.

Nov 13 '05 #3
DisRegard. I figured it out and for anyone interested here was my
solution.

I created two tables one tblDropDownNames (just had the Names of the
Drop Down List set with no duplicates)

I then inserted a subdatasheet based on my other tblDropDownValue which
had the category names beside each Value.

I created a main form based on the tblDropDownName and a subform based
on tblDropDownValue. I then used the combo box wizard and selected I
want the form to be based on the value I select from the combo box.

This made the subform change based on my selection from the combo box.
Now the customer can go to one table and select the combo name and make
changes to the subform datasheet below.

I believe this will be very useful. Thanks taking a look.

Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: NB | last post by:
Let's say in the product table I have around 50,000 products (well, infact it has now about 2000 only, but it's growing very fast, hence the question here) In the order form, users will select...
3
by: Marcus Canales | last post by:
Hello all, Here is my situation. I have a combo box on a form. The combo box is linked to a qry (qryCustomers) and the form is linked to tblOrders. The way I currently use the combo box is to...
8
by: Lyn | last post by:
Hi, Can anyone tell me how the initial value displayed in Combo Box is determined when a form is opened? I am loading the dropdown from one field ("CategoryName") of a table, with "ORDER BY ". ...
2
by: Gerry | last post by:
I have a combo box and I can populate it with my class of dat (the class allows me to store each userid,username called - see code below I want the user to select the dropdown and see the...
9
by: Edwinah63 | last post by:
Hi everyone, Please let there be someone out there who can help. I have two BOUND combo boxes on a continuous form, the second being dependent on the first. I have no problem getting the...
9
by: Vmusic | last post by:
Hi, I'm using MS Access 2002. I have a form with a combo box built from a query that returns one column, and that one column is the bound column. How do you use VBA to programmatically change...
1
by: Shawn Yates | last post by:
It has been a while since I have done anything on MS Access and I seem to be a bit rusty. I hope someone could help me solve my issue. I have a form that has multiple combo boxes on it. Each box...
5
by: Bface | last post by:
Here are the other 2 questions I have. I forgot to mention I am on Access 2003/Windows XP. The second and third question I have is on Combo box. Can a combo box be used to access several documents...
2
by: Sid | last post by:
I need some help in setting up Access combo box. I am using three comboboxes in my form. Comb Box 1, Combo Box 2, Combo Box 3. The row source for each of the combo box is a seperate table. ...
2
by: biganthony via AccessMonster.com | last post by:
Hi, I decided to install Office 2003 Service Pack 3 on my home computer to test (in full knowledge that there may be some issues with it). After installation, I have noticed that with a small...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.