I have a table
Expand|Select|Wrap|Line Numbers
- Operations
- OpeCompID *
- OpeSectID *
- OpeJobID *
- OpeOperID *
- OpeName
- OpeDesc
- etc...
- * stands for PK
Then I had add a subform which i want to be linked to the same table
Expand|Select|Wrap|Line Numbers
- Main Form name: OperationsForm ?????¿?¿?¿¿ See [Question 1]
- Record Source: Operations
- SubformName: TableOperations
- Source Object: Table.Operations
- Link master Field: OpeCompID
- Link Child Fields: OpeCompID
[QUESTION 1] how do I set or see my main form Name??? I tried to discover it with the following code, but im not sure if it is correct.
Expand|Select|Wrap|Line Numbers
- Debug.Print "Form.Name: " & Me.Form.Name & Chr(13) + Chr(10);
Expand|Select|Wrap|Line Numbers
- Form_OperationsForm.TableOperations.Form.Requery
[QUESTION 2]The idea is that when I input a new OpeCompID I got a detailed view of the current existing records (Operations) with this ID in the subform, this way the user can see the already existing entries for this operation code.
The same when I navigate with the first/prev/nex/last buttons.
The same when I load the form at first time.
Thanks a lot.
Sorry for my english :)