I have date picker which works correctly in form. When I put that form as subform to reports header calendar shows up but after selecting date on calendar textbox stays blank. Format of textbox is Short Date, Show date picker property is For dates.
I have form containing 8 comboboxes. On click on command button i want to set the item/caption/selection of combobox. How should I do that? Button has OnClick event built in VBA. What would be the code?
Thanks. Actually macros work. Problem was up to some IDs. I made some mistakes during importing data so my query which was data source for subform wasn't updated. Anyway, thanks to both!
It searches data which was in Access tables before upsizing, but when I update data in sql (backend) I cant search data I imported in SQL. I can see them when I open linked table, but macro does not search through them.
Hi! I am new at Access. I made simple application with navigational form which should edit some data. Search button is connected with Macro built in Macro editor. I upsized my Access file to SQL. Macros doesn't work after upsizing. I find that I would have to solve it by writing triggers in SQL...