unbound combo box to record

[capdownlondon]

what code do i need to use to copy the info in an unbound combo box, to a record from the click of a button? i ant to keep these field unbound by the way.

thanks

Adam

 

[gemma-the-husky]

you will either need to use a recordset

pseudocode will be

openrecordset
find record or addnew record
set record fields
update record (save record)
close record set

or you can use sql directly

insert into etc or
update etc


please note that this is much harder than using bound forms

 

[capdownlondon]

well the problem is, im using the calendar to update the records shown in a subform- this works perfectly, but only when i make all of the options (text boxes, combos etc) in the original form unbound. if they are bound to the values in the list then it doesnt work.

what i want to be able to do is add what is in the option fields on the original form to the rcord source, at the same time updating what is shown in the subform of the same record source.

basically when unbound, when i click any date on the calendar it shows only records from the date selected, but this wont work when the boxes are bound??????

its driving me nuts, its like, i can do both things i want, but not at the same time.

any ideas for a workaround????

thanks

 

[Guus2005]

Seems to me u have some serious problems with this form. Could you post it or a part of it describing the problem?

I always use the attached solution when using calendar forms: