form and pop form saving to different records

[mejia.j88]

Hi All,

I have created a database which 4 forms (1 main form, and 3 pop up).


In the main form, after the CutSize field has been populated through a combo box, one of the three pop-ups pop up depending on the value of the Cutsize field. The user then enters information in the pop up, that should be saved on the same record with the information from the main form.

problem: the information is saving to consecutive records, not hte same one.
the pop up saves to one record, then the main form to the record after.

is there a way to have both forms save to the same record. perhaps my database design is faulty, but i have deadlines that i must meet coming up rather quickly.

thanks
-j

[June7]

Would have to know more about your data structure and forms. Provide project for analysis. Having two separate forms acting on same record is tricky. That's the same as two users opening the same db and trying to edit the same record.

I don't understand why you need three popup forms.

[mejia.j88]

after compacting the db, it is at 538KB
i cant strip it anymore or else you wont be able to see what I'm talking about.
is there another way to make the file size smaller?

[June7]

Zip the file with Windows compression, 2mb size allowed.

[mejia.j88]

Thanks June7,
i have attached the database.

[mejia.j88]

Perhaps a better approach to something like this might be to use tabs instead of pop-up forms?
>.<
this is my second database i build.

[June7]

I can say I would not use 4 forms to try and edit the same data. Definitely would not have 3 identical forms. Two of the popups are bound to table, one is bound to query - why? Why 3 popups - what is the meaning of 040, 063, 125?

One query links the two tables on work order but work order is not primary key in either table. Neither is indexed and will allow duplicate work orders. Are the two tables a one-to-one relationship? A work order record must always be in both tables? If so, could be one table.

[mejia.j88]

the one bound to the query was an attempt to have it save to the same record as the main form (didn't work). the meaning of 040, 063, 125 are the different diode diameters we have. The 3 pop ups were an attempt to organize the lot numbers for preforms, pins and leads we use to build the diodes.
For example, 040 describes only the diameter of the diode, but 040 is a family of diodes, and it branches off to different types of diodes with 040 diameter; as a by product, different pins/preforms/leads are used. similarly with 063 and 125.
this is why i wanted to separate the information using pop up windows, so that the operators could choose the information easier.

i have abandoned this approach, as it seemed too difficult (and wrong). I have made tabs on the main form, which similar structure as the pop-ups, and now everything is saving correctly.