Show data in form by selection

[FrederikP]

I have a table in which inputs are entered on a daily basis. I do this to enter complete invoices for an entire month. I'd like to work with a sort of split-form which would give the details per invoice, per year and per month. At the moment, I can use a split form, but this gives all the data in my table at once. I would only like to see the data for the invoice, month and year I seleced. Hope I made it clear (see printscreen) and you guys could help me in the good direction?




Thanks,
Frederik.

[andy49]

A split form usually shows all the data you have in the data sheet part.

Have you considered a "subform"


Sent from my iPhone using Tapatalk

[FrederikP]

Hi Andy,

I worked with a subform and seems that I got it. Just wanted to know how to make the list updated if I make a selection. If you look at the selection I made for January, than the "FactuurID" is 20050, while in the list on top the "FactuurID" is still 20082 which is the previous selection I made.



Regards,
Frederik.

[aytee111]

User selects Year - Month listbox has a query which has a criteria of Year=Forms!Formname!Yearfieldname. In the OnClick of the Year you will have : Me!Monthfield.Requery.

User selects Month. In the FactuurID box the query has two criteria: year and month. In the OnClick of the Month you will requery the FactuurID listbox.

In the OnClick of the FactuurID event you will have: Me.Subformname.Requery

[Brightspark98]

From one novice to another,

Have you tried adding a cmdButton and assign a macro to refresh the form. I had a similar problem and this worked for me.

Mark