| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 22549 | 2002-07-24 07:43:00 | access 97 code, macro, or module | Bob Kehely (621) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 64829 | 2002-07-24 07:43:00 | Hi Folks, I have a couple of questions about a form and a subform No1 A form that has a combobox and several text boxes, I would like to be able to click the information in the combobox, and have the information relating to that information, reappear, in the relevant textboxes. And.. No2. have a subform, present the last entry at all times code or macro or module all would be appreciated. Many thanks, Bob |
Bob Kehely (621) | ||
| 64830 | 2002-07-25 02:08:00 | Hi, I'm a bit unclear on what you are after. For #1, 1) is the form based on a table or query ? 2) are the textboxes bound or unbound ? 3) I presume the combobox is based on a separate table/query to the underlying table/query of the main form ? I believe something like a Dlookup will be what your after but need to understand a bit more of what you are trying to achieve Not sure on #2 |
parry (27) | ||
| 64831 | 2002-07-25 02:59:00 | Look at the Orders form and subform in the Northwind sample database for how to do question 1 Question 2 - create a macro that (when run) will go to the last record of the subform. Enable the macro on the subform property - say - Got Focus, or the main form property - say - After Change - what ever is appropriate. DLookup may be beyond your current abilities. Stay with the online help with Access until your knowledge level drives you to other sources. |
Merlin (503) | ||
| 1 | |||||