Design View vs. Layout View

[Kayle529]

I'm working on an old database and am trying to fix a reoccuring problem. I'm new at Access though, so it's proven to be harder than expected.

To clarify:

1-I'm trying to fix a form for generating Quotes for our company.
2-The price information, description of product, etc. is already in our tables and queries, but when I try to get it to appear on the form, it doesn't show up. Is this a relationship problem?
-Also, when working with forms, if the information about each product is visible on the design view, why is it not showing up on the layout view of a form?

Please help ASAP,
Kayle

 

[Pat Hartman]

Is the form bound to a query or table? Open the properties dialog for the form and look at the recordsource which you will find on the Data tab?

 

[Kayle529]

Thanks for the response, Pat.

The form should be bound to a query, so doesn't that mean that the value should be pulled from the query? Right now the control source box just displays the name of the item, like "NetAmount", but it's not bound to anything. Should I go into datasheet view and add the "Row Source Type", "Row Source", and "Bound column" fields?

Thanks for the help!

 

[Pat Hartman]

If the control source contains the name of a column from the recordsource, the control is bound and will show whatever is in that column.

The Row "Source Type", "Row Source", and "Bound column" fields are used for combo's and listboxes. Is that what this control is supposed to be? If it is supposec to be a textbox, use the Format/Change to to change it to a text box. If you want it to be a combo, your best bet is to delete the control and start again and let the wizard build the combo for you.