form with different queries

[bbeernaert]

HI



Is there any way to use an expression to create a form with the queries you want??


So example

I want a form with the column monday if its monday

If it is tuesday I want another column in that form.

Thx!!

[weekend00]

I assume you have fields "Monday","Tuesday"..."Sunday" in you table.

change data source in form_open event:
form.recordsource="select "+format(now,"dddd")+" from tablename"

[bbeernaert]

I have solved it by putting a bigger screen and put al the days of week on the form!!

srry for bottering