Lakshmi has attended:
Access Intermediate course
Access Advanced course
Forms
I need to find out how i can have other fields 'pop up' in a form based on my choice of variable in the main form.
RE: Forms
Hi again Lakshmi,
I'm not going to try and answer your posted question, but yesterday you asked when to use "Is Null" and when to use 0 and it wasn't really explained.
"Is Null" vs 0 (zero)
A null value is when the field does not have a value, no data has been entered into it. This can also occur in a number field, and not only a text field. The value 0 is an actual value of zero. The person has entered data, and they have say
RE: Null vs Zero
Sorry, the table wasn't posted correctly. Going to try and post it in another way. Hope it makes more sense.
ID----Name (text)----Amount (number)
1-----Anna-------------__
2-----Mary-------------0
3-----____-------------20
4-----Peter ------------10
RE: Forms
Dear Lakshmi
Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.
If you have set up the relationships between tables then you can create a subform within a form for those tables.
The main purpose of the forms and subforms is that you can view the content of one table while viewing the details of another related table!! The best example for this is that if you have a table called customers and have another table called Orders. you can create two separate forms for each of the tables. Then you can open the Customers Tables and within that have the Orders form as a subform. You can view the customers and their corresponding orders on the same form.
I believe we covered forms and subforms in our Intermediate course. If you are not sure how to create subforms then please let me know and I should be able to guide you.
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please either reply to this post or post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
