combo box question

[stevencarroll19]

any help would be much appreciated on this, I am not exactly an expert with access!!

I have a basic database that enables a user to enter questionnaire results via a form.

A form is completed for each set of questionnaire results (and the date the questionnaire was completed is also recorded via a combo box. The date is entered into tblDate prior to the questionnaire results being entered.

Say for example 10 were completed on the 20/10/2006, this requires the user to continue to select the date for each questionnaire result.

I want to be able to select this date via a combo box on a seperate form prior to entering the questionnaire results, so that it only needs to be selected once.

Really it is just to increase userfriendliness!


Can anyone help at all or point me in the direction of an answer!!

Many Thanks

[NeoPa]

Normally, to have more than one form open at any one time, you need to have it related as a subform.
I'm not sure if this would work though - You could consider opening a form in modal view.
That may give you a 'floating' form. If a subform will do - it may prove the more straightforward method.

[stevencarroll19]

is it something simple to do?

sorry for my lack of knowledge on the subject

[NeoPa]

Few things are simple when you've never done them ;).
My experience with forms is mainly with unbound menu type forms rather than those bound to datasets.
I can work with those (and even subforms when I have to) but I can only do it step by step with reference to the details in front of me. I'm not really able to guide in this are very often (sometimes I can, when the question is about something I know).
This should give your thread a bump anyway.