When you choose a year in the form fill in the right records

[knoet]

I have a form, when you choose a year in the combobox, how to fill the right records in the form?

 

[mike60smart]

I have a form, when you choose a year in the combobox, how to fill the right records in the form?

Hi

Your 1 table is not normalised as it contains Repeating Groups.

The fields listed below should be Records in a Related Table and not fields in this table.

USENET

USENETbegindatum

USENETeinddatum

USENETlogin

 

[jdraw]

knoet,

Can you step back and tell us a bit about your database application? Not only do current readers need some context in order to offer focused advice, but anyone reading this post in future would be "lost/confused" without some additional descriptive material.
What is/are "right records? Sometimes adding some detail to your post will help clarify things for you and readers.

 

[arnelgp]

you try this Abo

 

[arnelgp]

You hid the bound year field so it won't be possible to add new records and as you scroll,

the original form does not have the Year field on it, i just added it.
on the BeforeInsert event, i set the Year field to the value of the combo.

 

[knoet]

Sorry, I just seen your answers, I never got a noticifation in my mail.
I wil study your anwers.