snehal0909
Registered User.
- Local time
- Today, 13:50
- Joined
- Feb 4, 2008
- Messages
- 74
i have three questions this time.
1) I have a form that is sort of lookup form (users can enter data into that form & that data then will appear in main form in drop down box. WHAT WOULD I NAME THAT FORM?
Is "fdlgIncidentType" proper name? I couldn't find one in naming conventions. -
(I have read this page but i still want to create edit button next to lookup field & that button will bring up form that allows editing records in my lookup table).
I HAVE ATTACHED THE DATABASE View attachment db.zip - CLICK ON "EDIT" on the form that opens up when opening the db. Then you'll see another form - click on + sign next to Incident Type.
Hope that gives you better understanding of what i am after.
The following two questions are related to the form that opens when user click on + sign.
2)how can i specify the size of a datasheet?
size is going to be w=325 & H=500.
3) how do i auto refresh the form so when i add any new data in lookup field, it shows up right away on the main form?
If you're suggesting VBA code then, please tell me where to put it.
I am using ACCESS 2007.
Thanking you for all your help so far.
1) I have a form that is sort of lookup form (users can enter data into that form & that data then will appear in main form in drop down box. WHAT WOULD I NAME THAT FORM?
Is "fdlgIncidentType" proper name? I couldn't find one in naming conventions. -
(I have read this page but i still want to create edit button next to lookup field & that button will bring up form that allows editing records in my lookup table).
I HAVE ATTACHED THE DATABASE View attachment db.zip - CLICK ON "EDIT" on the form that opens up when opening the db. Then you'll see another form - click on + sign next to Incident Type.
Hope that gives you better understanding of what i am after.
The following two questions are related to the form that opens when user click on + sign.
2)how can i specify the size of a datasheet?
size is going to be w=325 & H=500.
3) how do i auto refresh the form so when i add any new data in lookup field, it shows up right away on the main form?
If you're suggesting VBA code then, please tell me where to put it.
I am using ACCESS 2007.
Thanking you for all your help so far.