How to enter data in one table with two forms

[ansar.abdulhai]

Hello ALL,

I have a table which has several fields. Data into these fields are entered by two separate forms at different times. Data from form1 will be stored and saved say in one record and form2 which is filled at different time should save its values into the same table within the same record. How do I do that?

----Please advise.

 

[HiTechCoach]

Hello ALL,

I have a table which has several fields. Data into these fields are entered by two separate forms at different times. Data from form1 will be stored and saved say in one record and form2 which is filled at different time should save its values into the same table within the same record. How do I do that?

----Please advise.

It is possible to use many forms to edit the same record source (table) .

I assume the first form will add the records.

The second form will edit he record. They key will be to have the ability to search and find the record you want to edit.

How will you identify the record to edited?

 

[ansar.abdulhai]

I agree with that..... But both of my forms will be data entry forms.... and not editing forms......... I am splitting one half section of the table fields and including those into form1 and the other set of fields into form2. But, form1 and form2 will be filled at different timings. I wanted the data pertaining to one record filled by form2 go in the same record when form1 is filled. How can I do that?

 

[Rabbie]

I agree with that..... But both of my forms will be data entry forms.... and not editing forms......... I am splitting one half section of the table fields and including those into form1 and the other set of fields into form2. But, form1 and form2 will be filled at different timings. I wanted the data pertaining to one record filled by form2 go in the same record when form1 is filled. How can I do that?

Because you want to change an existing record at certain times this is in fact an Edit. Just because you are not changing fields already entered but adding data to previously unentered fields does not stop this being an Edit. This means you need to plan how you are going to do this.

I would suggest something along these lines.

1. Check if the record is already present. If so then go into Edit mode and update the fields you want to change.

2. If the record is not already there then add the record as required.

 

[ansar.abdulhai]

Hello Rabbie,

Thanks a lot for the reply..... I understood how I should prepare my forms. But, as I am a beginner and I don't know the programming, can I get a sample code of searching a particular record and if present editing it and if a record is not present in the table then creating a new record in it?

--- I really appreciate your help and guidance in this direction.... Thanks a lot.