OK, so I get that bit and can see how I can use forms that don't update the database (Thanks to all those who helped). However:
1. This form was created in a wizard that tied the form to a table. Only the combo box is unbound, or did that change the whole form?
2. If the information on the...
That seems to have fixed it, but I don't understand the difference between bound and unbound, except that the unbound combo doesn't have a control source.
I'm sure that there must be a good description of these properties somewhere.
Thanks for the help.
Kev.
The UK's greatest vacant memory space!
But It's still not quite right!
It allows me to select from the combobox, but when I close the form it has updated all of my suppliers names with value from the suppliers ID.
The combo box is looking up the suppliers name.
suppliers ID is the key field on the table.
What else have I missed...
I have tried this with several variations and seem to come back to the same problem:
My code in the on Change eventProcedure looks like this (cloned from FAQ)
Private Sub ComboSupp_Name_Change()
Me.RecordsetClone.FindFirst "[supp_Name] = '" & Me![ComboSupp_name] & "'"
Me.Bookmark =...
I want to make a form that has a combo box where the user selects a name and the rest of the data on the form (from same table)updates to show the rest of the record.
I have already created the form using the forms wizard and then created the combobox by selecting the tool and then the field...
sorry missed the attachment
can't find out how to attach it.
message reads as follows
Run-time error '2147352567 (80020009)':
Cannot add record(s);Join key of table Project_Info' not in record set.
My SQL in rowSource looks like this:
SELECT Project_Info.proj_name...
Thx Zameer,
I did that but access tells me that I don't have a join key in my record set.
(See attached screengrap of message.)
I have 11 fields on this combo box only the contract number is visable all others are set to 0cm width.
My code looks like this:
[code]...
I have an 'add new order' form which opens with all the fields blank and focus set to a combo box.
The first thing the user must do it select a contract name or number from the unbound combo box. I then want the form to update and show all the relavent information in the form fields. - How do...
Frank,
Thanks for this, I thought I had found the solution at last, and I probably have, But I can't make it work yet and I suspect it's my SQL (lack of) skills that are letting me down.
My afterupdate code looks like this:
[code]
Private Sub comboCatagory_ID_AfterUpdate()
Dim...
I'm Sorry I must be thick!
I cant find an item labled 'item collection' in the combbox values. And I can't find a solution in the FAQs that adds a record to the bottom of a list so the user can select it.
I would like to do this with standard features so the user can select it and then use...
I have a combo box which lists products. I want to add a record at the bottom of the list to 'Add new product'
If the user selects 'Add new product' I want to open the products form.
How do I add the 'Add new product' entry into the combo box list.
Thx.
Kev
Thanks Zameer,
My sever is down this morning, so I can't try this yet, but looks like it would work. However the main problem is trying to keep the project data in the form fields that relate to the project and not the order record.
I can see this working two way:
1 retain all for project and...
I have an orders form that looks up data from 3 tables (projects, orders and orderDetail) with a subform that looks up data from a query.
The form has several unbound comboboxes relating to the project that synchronise with VBA code
Projects are setup in another form and this form is only used...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.