Search results
-
A
Subform slow to update
I wonder if anyone could offer some advice on a problem with a form & subform? I have a main form, based on table PublicationOrders: POrderID (pk) EventID(fk) And a subform, EventDisplay, based on table Events: EventID (pk) EventName The main form and subform are linked on the field EventID... -
A
Help needed with calculated query and count function
I've created a totals query to count the number of places that have been booked on each course. In the same query, I would also like to display how many spaces are left on each course. However, the expression: Places Left: Sum([Capacity]-[Booked Places]) gives me the error message "Can't... -
A
Synchronising Combo Boxes
On a sub-form I have two cascading combo boxes; cboParent which allows the user to select a year and cboChild which then allows the user to select a course dependent on the year selected in cboParent. I created these using Mile-o-Phile's method in the FAQ here. However, when I scroll back...