Cmbo box is resisting my efforts

[workmad3]

Ok, I have a form (unbound) that I have written my own load and save methods for. On one of the subforms (there are about 5) there is a combo box that is populated with a select query. I save the ID from the combo box into the database, but I am having trouble getting the combo box to then load this back in to get to the correct entry in its list.

Any ideas?

 

[Oldsoftboss]

The subform needs to be bound to a table, the combobox needs to be bound to a field in that table

 

[workmad3]

not an option at the moment.... mainly because I dislike bound forms and so the system is designed to not use them.

 

[workmad3]

finally fixed the problem. Ended up needing to set the bound column to a non visible column and setting the frameID through that. Means I can't put in my message saying nothing is selected, but a blank line is just as obvious.... it will just have to do I guess

 

[Banana]

Can I at least ask why are you even using Access at all if you dislike bound form? Why not VB .NET which is essentially same, but with more robust language and libraries?

 

[workmad3]

Because access is what my boss wants me to work in

I personally would have done exactly what I have done in C++, Java or C# a lot more happilly.... but the boss decided access is what would be used

Oh, and my dislike of bound forms is that I find they restrict me too much. I like to be able to define how things get saved and loaded and bound forms tell you how things get saved and loaded rather than vice versa