Search results

This is probably very easy, but I have not been able to find an answer. I am using DLookup to pull info from a table based on the selection I have on one of two forms. If form A is open I want DLookup to use the selection from form A otherwise I want it to use the selection from form B...

I have a form a user uses to add to a table "Categories". I would like to have a record automatically created in another table "Subcategories" each time a record is created in the "Categories" table. The "Categories" table and "SubCategories" table are related by the Category_ID field. Any...

I'm not quite sure how to go about creating the kind of report I need. I have 3 tables, I'll call them "Categories", "Sub-Categories", and "Line Items". I want to print a report that shows on the first pages each "Sub-Category" grouped by "Category". Then I would like to have each "Line Item"...

I have 2 list boxes that are synchronized. The idea is for a user to select an item in the first list and then select an item in the second list (if there are any.) I have this part working. The user then presses an "Edit" button to open the record that the selections refer to. The problem I...

This has got to be simple but I can't get it to work. I have a "Date_Modified" field that I want to be updated with the current date when I double click on the field in the form. (Not On Enter as my title suggests, my mistake) I added the expression =Date() to the text box Event "On Dbl Click"...