Control Source

E

Ernst Guckel

Hello,

Maybe I am missing something but a control's 'Control Source' property is
the field name within a table or query where it gets its value and in turn
updates such value. Well if a table has a Primary Key of AccuralID &
TypeYear and a form has a combobox 'cYear' bound to 'TypeYear' then how do I
bind another control to the unique record of AccuralID & TypeYear?

Each year I track the number of sick,personal, and vacation time an
employee is allowed to use. So the tAccurals table should have a unique
record of 'Year, Type, Allowance, & fields for each date used.' For 2005
there should be 3 records for each employee (Sick, Vac, Personal) Just
cannot sort it out in order to put it on a form...

Any guidance would be great...

Thanks,
Ernst.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Control Source 2
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
if statement = if number is between 1
Data from from field not found in table 1
Textbox control source problem 10
Using DSUM to get running total on a filtered form 0
Function as a control source? 3
Calculate leave time in a query 4

Top