Updating form from datasheet

[srcacuser]

Hello,
I'm still a noob and trying to find out how to accomplish this.



I have a form with many fields that also contains a subform at the very bottom. After a user searches for a record(s) in the main form, the filtered results show up in the subform. The default view of that subform is a datasheet. It has record selectors, so I can see that I can move between records when clicking. Is there a way to update/refresh the main form above with the exact record that is highlighted in the subform?

Afterupdate in the subform?

Thanks in advance.

[Toyman]

There are many ways of doing this depending on how your form is set up. Post your db here so we can take a look

[srcacuser]

Toyman, sorry for the delay. I had to sanitize and enter dummy data.

I'm trying to make a simple way to retreive/view drafting records. Each record has a drawing number. There may be many records sharing the same drawing number, but the revisions (REV) are unique to each new record: Ascending X0, X1, and so on.

The main page is the SEARCH_DATABASE1, which has a find-as-you type module for quick record searching. At a desired record, the EDR button on the left will bring up DRAFTER_INPUT, with DRAWING HISTORY as a subform at the bottom of that form. DRAWING HISTORY shows all the revisions of that particular drawing number as a datasheet.

(*I gave the "LEGACY CONVERSION" dwg four revs, so it's our test).

How can I have DRAFTER_INPUT up, and scroll back and forth through just the revisions of that drawing number so that the parent form updates? To select a record in the subform datasheet and then requery DRAFTER_INPUT form?


I am normalizing and trying to clean it up this week. There are currently 14k records in the DFTRP (main) table. It's a hand me down for sure.
Suggestions on restructuring the whole thing welcome.

[Toyman]

Something like this?

[srcacuser]

A split form is doable.

I'm still trying to get just those isolated revs to show up in the split form, and not all the records (24).

Perhaps a filter on-load? I see REMOVE FILTER on-load now.

[Toyman]

A split form is doable.

I'm still trying to get just those isolated revs to show up in the split form, and not all the records (24).

Perhaps a filter on-load? I see REMOVE FILTER on-load now.

I am not really understanding what records are suppose to be display. Perhaps tell me the list that is suppose to be display, and I can get the common deminator and work out a filter

[srcacuser]

The idea was to locate a specific record/revision on the SEARCH_DATABASE1 form, then open that record up in DRAFTER_INPUT to
see all the data in that form for that record. A subform needs to exist at the bottom that shows (for convenience) all the records/revisions that exist for that particular drawing number, versus all the records in the database in continous form. The user needs to be restricted to seeing only the revisions for that drawing, ie toggling back and forth between available records/revisions. X0 thu X4, or whatever.

That help a bit?

Thanks again for your help

[Toyman]

The idea was to locate a specific record/revision on the SEARCH_DATABASE1 form, then open that record up in DRAFTER_INPUT to
see all the data in that form for that record. A subform needs to exist at the bottom that shows (for convenience) all the records/revisions that exist for that particular drawing number, versus all the records in the database in continous form. The user needs to be restricted to seeing only the revisions for that drawing, ie toggling back and forth between available records/revisions. X0 thu X4, or whatever.

That help a bit?

Thanks again for your help

Ok, try this:
However, I think your set up may be wrong. You should have a main table for projects. In this table, you should have a primary field ProjectID, auto number, to identify your project. You should then have a second table to record all the record/revision for that project. The second table should have a primary key RevisionID and a foreign key to record the primary key from the main table. Therefore, you will have one main project will multiple revision entries.

[srcacuser]

So for now there is no way to accomplish this?

[Toyman]

So for now there is no way to accomplish this?

Its done in the sample db I attached. However, I would change the structure. It may cause problems in the future

[srcacuser]

I replied not seeing the attached. That's exactly it. Thanks very much
Toyman.