text box to see changed data for a given field

[fabiobarreto10]

gentlemen,



I have a subform with the following fields: step, the scheduled date, time and date performed and rescheduled counter. I have an audit table which is the history of all user actions. I tried that when I click on the rescheduled date of a certain step, show a text box in the table data audit this specific field.
I'm having trouble writing vba code and which event.

[June7]

Do you want to display one value (such as count of records) or all the records.

Using a textbox to display data from multiple records requires VBA code to concatenate the data. A listbox or a subform can easily list records. A listbox can have multiple columns - a column for each field of the RowSource, textbox does not. Check this tutorial http://datapigtechnologies.com/flash...combobox3.html

Sounds like need to use the Click or OnFocus event of a textbox to open another form that will display the records filtered to the selected step ID.

[fabiobarreto10]

I think a subform would solve. It is possible that it is in the same form? That is, when the user clicks on the rescheduled date field, some specific steps to show the sub, only the past history (date, time, user history and dates) of the rescheduled date of the step?

[June7]

This tutorial shows how to link a subform to another subform, both on same main form http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp

[fabiobarreto10]

I create a subform, and the wizard did not appear, was not fits on. By linking the fields father and son, appeared a message box: Could not create a link between forms not fits on.

[June7]

No, can't link a subform to subform by conventional method. The wizard won't help. Did you review the tutorial?

[fabiobarreto10]

June7, I understood the tutorial. I lowered the seat, and made the example of a site related to form. It worked ok.
As my form has different characteristics that you would like to confirm some things.

I need to create a form, only the table fields PassosStatus?!
Then create a form with the fields of audit table table PassosStatus?!
I need to make a new form, with the combos ...?! or can adapt to the form that is ready? I tried to adapt but some errors occurred.
Thank you.

[fabiobarreto10]

June7 apparently managed to do.
For some reason, when trying to insert a new step, the following message appears:
You can not add or change records, it is necessary that he has a related record in table 'TblProduto'. I could not identify the error. Can you help me?

[June7]

The Master/Child link properties of the subform container control holding frmTblPassosStatus are not set.

[fabiobarreto10]

Well, I defined the relationship as the tutorial, and sub child (or grandchild) is functioning normally. See the registration. I am having trouble registering directly on the form. I have to open the table analyst, and register an analyst. Then, Company ...

[June7]

You did not set the Master/Child links properties of the subform container control holding frmTblPassosStatus.

[fabiobarreto10]

June7 apparently succeeded. You were right, just put CodProduto was missing father and son in the properties of the subform. It seems that is running fine. I'll mark the post as solved and open another topic to another problem I'm facing. As you already have some idea of ​​my db, I can direct you to the topic?

[June7]

I will look for the new thread.