Search results
-
O
Temporary table as subform's record set
Hello, I need to use a temporary table as recordsource for some of the controls in my subform. I tried to get the main form to create the temp table (run create table SQL OnOpen) but I keep getting an error saying that the recordsource (for the subform) does not exists, then when the form... -
O
How to allow the user to select a record from a form to populate another form
Hi, I am working on a warehouse database for a charity that collects and distributes donations. The charity accepts all sorts of donations (food, clothing, furniture etc.) When a donation comes in, an "addition receipt" is created, containing a list of all the items that a donor brought in... -
O
Perevent user from leaving the subfrom blank
Hi, Is there a way to prevent users from entering main form data, then exiting (or moving on to a new record) without entering a single line in the subform? I want to prevent the user from creating empty receipts (i.e. entering receipt number and date, and not entering any "items" in the... -
O
Subform retains cursor position from previous page and causes error
Hello, I am facing a strange problem, I've looked everywhere for a solution but couldn't find any previous posts about it. I will try to explain as best as I can, but it's quite hard to describe. I have a main form with two fields, and a subform with 5 fields. The main form has...