Editting existing Access 2000 form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi; I'm editing and updating and existing form with only little experience or
knowledge (!) in how to go about it. I've been pretty successful so far but I
have a couple snags.
This is basically a service database form that has three print options, the
third of which I just added, and it works except for a couple fields I added
to keep track of a tax ID and customer number. I can't seem to link these
two fields correctly to the rest of the database; When I click my print
button it asks for the data, even though I entered it in the form.
Thanks in advance for your help.
Jim Vanderwiel.
 
Is your report based off a query. You may have to refresh the data before
printing by putting
Me.Refresh before your code to print or in your macro to print.

I do not understand what you mean about linking the fields to the rest of
your database. Are these new fields in tables? How are your tables set up
and how are the relationships?
 
Did you add the fields to the table underlying your form?
Did you set the ControlSource for the new textboxes on both the form and the
report?
 
Hello Jackie,

Forgive me if I can't relate what I'm trying to accomplish very well, I'm
not real familiar with the terms and levels of interaction between objects in
DB programming.

I have a form for service records and billing that with two buttons prints
two pages of information; I needed a third page, and a couple additional data
fields. I selected a similarly formatted field (in design view) and copied
it, pasted it, and changed some of the properties to reflect my needs.
The problem is when I print and these new fields don't always have data in
them, a pop-up window asks for the data. I can't quite figure out how to
prevent this, as the fields I copied worked correctly without 'asking' for
data if it wasn't present.

Can you tell me what I'm overlooking?

regards,
Jim Vanderwiel.
 
It looks like I've done both these things, (properties) using similarly
formatted fields as examples. Thanks for the input, I'm still trying.
 
Jim,

Are these fields used as parameters/criteria in your underlying query?
Otherwise, are these fields bound to the correct field from your query.
Check the control source property to make sure it is correct. Also, it just
came to mind, are you printing the form itself or are you printing a report
based off the information in the form?

Let me know.
 
Hello Jackie,

Clicking the print button(s) prints a report based on entered data. It looks
like the control source data is correct, if I look at others fields for
example. I have not yet tried adding the syntax "me.refresh" to the print
code. Should this be in a separate line at the beginning?

Also, can you tell me of a good online source to read more about the basics
(I'm a "for dummies" candidate!)?
I need to understand the difference and properties of tables, reports,
queries and forms in more detail; a flow chart would be useful, I think.

thanks very much,
Jim Vanderwiel.
 
Back
Top