View Full Version : access 97 code, macro, or module

Bob Kehely
24-07-2002, 07:43 PM
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,

25-07-2002, 02:08 PM
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

25-07-2002, 02:59 PM
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.