couple of problems

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

I am new to access and I am using access 2002. I am trying
to create a recipe database for a business and I have run
into a couple of problems that I don't know how to fix:

1. when I am entering data in the forms vies, I have a
subform and it stops in the middle of the form. Its for
ingredients. I don't know how to make it any longer so I
can add all of the ingredients.


2. I have 3 fields which are not always the same...
everytime I type something in to each of these fields it
copies to all of the records. How do I stop it from doing
this???

Thanks in advance.
 
I am new to access and I am using access 2002. I am trying
to create a recipe database for a business and I have run
into a couple of problems that I don't know how to fix:

1. when I am entering data in the forms vies, I have a
subform and it stops in the middle of the form. Its for
ingredients. I don't know how to make it any longer so I
can add all of the ingredients.
Click to expand...

A Continuous form will have a scrollbar on the right side of the form.
You can use this to scroll down and see any number of records, more
than could fit on any screen. One of the Form's Properties (visible by
opening the form in design mode and selecting View... Properties) will
let you hide or display this scrollbar. Is this a form that you built,
or someone else?
2. I have 3 fields which are not always the same...
everytime I type something in to each of these fields it
copies to all of the records. How do I stop it from doing
this???
Click to expand...

It sounds like these are "unbound" controls. If you view the
properties of the control (again, in form design view) and look at the
Control Source property on the Data tab, what do you see - nothing?
Should the information in this control be stored in a table field? If
so the Control Source should be the name of that field.
 
If you are having problems with subform, try having 2
forms appear on the screen. Create two forms which
contain related data but different in a sense that will
appear at the same time on your screen. Do it by creating
a macro that has a command OpenForm for the first form
and another command OpenForm for the second form. Then
call this macro in your query statement. Hope it
helps........Gil Lopez
 
Back
Top