Data Entry

[DBA-Meister]

I have (among others) three linked tables as follows:
Match Dates (WeekNmbr, CalDate)
Person (ID, FName, LName)
Scores(ID, WeekNmbr, Scr1,Scr2,Scr3)

I am trying to build a score entry form (with sub-forms) such that the data entry person clicks on CalDate, then clicks on ID of any one person, and can then enter the three scores for that person for that date.

I have tried dozens of different forms and sub-forms, but cannot get the data to show up. Anyone got any ideas?



[ I am new to access, but have extensive experience with Sybase. ]

[June7]

You tried a form bound to Scores with comboboxes to select WeekNmbr and PersonID?

[DBA-Meister]

You tried a form bound to Scores with comboboxes to select WeekNmbr and PersonID?

Thanks. I think that will work. I tried it and it does produce a list from a table, but the list is not visible until it is clicked. Is is possible to pre-populate the list in a scroll window?

[orange]

Is there more than 1 score per person per week? You may have to add a ScrDate to identify individual records.
Suggest you normalize this table
Scores(ID, WeekNmbr, Scr1,Scr2,Scr3)

[DBA-Meister]

I have a bound combo box that paints a list of "players" when you click in that box. I also have another combo box bound to the the same form that paints a list of "match dates" when you click in that box. However, neither box paints the list UNLESS and UNTIL you click in the box. There is a an "effective" score date in the Scores table by virtue of he WeekNmbr field which maps to a date in the MatchDates table.

I would like the combo boxes to be pre-populated when the form is oepned (before any "clicking"). Is this possible? Alternatively, could the boxes be populated when they "get focus"?

[June7]

The comboboxes have a RowSource then their lists should be populated when the form opens. I don't understand what you are describing.

[DBA-Meister]

I solved this problem. I just changed the "combo" boxes to "list" boxes and everything works smoothly. Thanks all for your suggestions. I treat every wrong road as a learning opportunity.

[Missinglinq]

...I tried it and it does produce a list from a table, but the list is not visible until it is clicked. Is is possible to pre-populate the list in a scroll window?

Sorry about not helping you with your question, but you had everyone fooled here by your incorrect use of the terms '..the list is not visible until it is clicked' and '...pre-populate the list...'

When you said "until it is clicked" everyone assumed that you meant clicking on the Combobox Control, i.e. bringing Focus to the Control, when, in fact, you meant "dropping down the Combobox." The entire Row of a Combobox is never seen until it is dropped down! That, in conjunction with your question about "pre-populating the list," led us to believe that no data was actually appearing in the Combobox until it had received Focus! The Combobox was, in fact, already pre-populated and working quite properly! The point in using a Combobox, as opposed to a Listbox, is just that...the Combobox takes up little space until it is being used, while the Listbox always takes up a great deal of space! In the future, in order to have the list drop down upon moving to the Combobox, use code like this:

Private Sub ComboBoxName_GotFocus()
 Me.ComboBoxName.Dropdown
End Sub

Good luck with your project!

Linq ;0)>