Default, Populated Fields

[NewfieSarah]

Hey All, I have a main form PID and and Building form I need to have the data from the building table display on the building form, upon adding a new record. Since my PID form and building form are linked to show the same records. PID Form contains- PIN NUM, ADDRESS, PARID. The Building form contains, PIN NUM, DATE, PHONE, OWNER, SIZE, LOCATION... I open my main form filter my results for my reocrds to show up... PIN-20053227, ADDRESS-MAINSTREET, PARID-NEWFIE22. This data is obtained through the PARID table. Now I click on the command button to see my building forms, there are 6 records, here I have the ability to add, modify, delete, save... What i want to do is add a new record, but have some generic fields appear from my table. since my name, PIN, address hasnt changed. So I would like to click add, and have appear from the building table, OWNER, PHONE etc... How might I be able to do this?? Thanks

 

[NewfieSarah]

Hi.. the new records are on the "sub"- forms they are linked through command buttons.mulitple command buttons on the main for lead to different "sub" forms. depeding on what record you working on, on the main form it loads data for that record on the different "sub" forms. then i would like the data related to that reocrd to copy to the add form, which is that form but in edit mode.

 

[hermanlaksko]

But are they sitting on this main form ?

Herman
Say no to macros

 

[NewfieSarah]

the command buttons are sitting on the main form yes

 

[hermanlaksko]

I am talking about the "sub"-forms where are they located.

Herman
Say no to macros

 

[NewfieSarah]

Where are the "sub" forms located?? in my database? all my forms, reports, queries are all in the same database and my tables are located inanother database and linked. is that what you mean??

 

[spizotfl]

are the subforms embedded in the main form or are they free floating?

 

[sdk]

Hi

In the post at 2 Nov 05 10:57, should this criteria be:

"[PIN] = '" & forms!YourMainFormName!YourCtrlName.Value & "'"
(note the extra apostophes)

also would've thought the reference would be to a key value, not an address.

Cheers

S.