Form -Subform refresh

**Ruchval** · Feb 9 '16, 02:53 PM

Hello again,

I have a table

Code:

 Operations
  OpeCompID *
  OpeSectID * 
  OpeJobID *
  OpeOperID *
  OpeName 
  OpeDesc 
  etc...

* stands for PK

I had build a Form to maintain this table.

Then I had add a subform which i want to be linked to the same table

Code:

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.

Code:

Debug.Print "Form.Name: " & Me.Form.Name & Chr(13) + Chr(10);

To try to refresh the subform, I had used this code in the "btnNext_OnClic k()" based on the previous Debug.Print

Code:

Form_OperationsForm.TableOperations.Form.Requery

The debugger doesnt crash or cries ;-), but I see nothing updated in the subform.

[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 :)