Taking data from one table and inserting into another through forms

[Sumith76]

I am preparing a database for a survey. For ease, I break the table into different ones like a BaseTable with HouseNo, OwnerName, Address, a HouseTable with HouseNo, OccupantNo, Ownership, MaleNo, FemaleNo, BirthNo, DeathNo, etc, . The HouseNo is taken as the Primary key in all tables and I have created one-to-one relationship between BaseTable and all other tables. I have also created forms based on all the tables for data entry. What I want to do now is:

I will enter house no, name of owner, address of owner, etc in the BaseForm and from the BaseForm I'll navigate to the HouseForm. In the HouseForm, I want the house no which I entered in the BaseForm to be displayed and also this house no should be inserted into the HouseTable when I move on to the next Form. How can I do this?

Thanks in advance.

[Rabbit]

When you open the form, pass the house number in the OpenArgs parameter.

[nico5038]

By making the BaseTableinto a MainForm and using the other tables as linked subforms, you can get the additional tables with the same house no filled automatically.
All you would need to do is to limit the number of entries in the subform to one, or you would need to insert for all tables a new entry when adding a new house no and set the subforms to "no additions allowed".

Nic;o)

[Sumith76]

Thanks for the reply. There is a button in BaseForm which opens the HouseForm and simultaneously closes the BaseForm. I tried the openargs parameter of the openform method of this button. I gave the argument as HouseNo = BaseForm.HouseNo. Not sure whether the code is correct. Could you please comment?

There was another reply to my question - to make all other forms as subforms. But I don't want that b'coz I don't have much idea about subforms.

Thanks in advance,

[Rabbit]

OpenArgs by itself does nothing. It only stores a value. In the form that opens you need code that will fill in the value for you in the On Load event.

[nico5038]

Just use the subform button from the toolbox and follow the wizard.
When it proposes to link the subform, accept the proposed field and see the effect.

Nic;o)

[Rabbit]

I suggest you do what nico is proposing, it'd be a lot easier to use the subform wizard than try to figure out how to use openargs correctly.