How do you render a record in a continuous Data Entry Form?

  • Thread starter Thread starter Iram
  • Start date Start date
I

Iram

Hello.
I am using Access 2003. I have a continous form that is two pages long that
is all one record. At the end of the two pages I created a button that takes
the person to another form. This other form opens based upon a common field
with the first form. Since the data on the first form has not been rendered
to the table (pencil picture in the record selector) and since the second
form is a continuation of the first form (same record) it doesn't work. How
should I render the record in the first form so that the second form knows
how to link? How should I go about fixing this issue? Please describe in
detail since I am new at this.

Thanks.
Iram/mcp
 
Iram said:
Hello.
I am using Access 2003. I have a continous form that is two pages long
that
is all one record. At the end of the two pages I created a button that
takes
the person to another form. This other form opens based upon a common
field
with the first form. Since the data on the first form has not been
rendered
to the table (pencil picture in the record selector) and since the second
form is a continuation of the first form (same record) it doesn't work.
How
should I render the record in the first form so that the second form knows
how to link? How should I go about fixing this issue? Please describe in
detail since I am new at this.

Thanks.
Iram/mcp
Click to expand...

In your button's OnClick event code, include the line:

Me.Dirty = False

This will ensure the record is saved (rendered) before you open the second
form.
 
Thanks. Your the man!


Iram/mcp

Stuart McCall said:
In your button's OnClick event code, include the line:

Me.Dirty = False

This will ensure the record is saved (rendered) before you open the second
form.
Click to expand...
 
On a different form I have a macro on the "On click" of a checkbox that opens
another form and closes a different form. I need to do the same thing as far
as rendering however in a macro. How would you suggest that I do this in a
macro to render a record?

Iram/mcp
 
Hello.
I am using Access 2003. I have a continous form that is two pages long that
is all one record. At the end of the two pages I created a button that takes
the person to another form. This other form opens based upon a common field
with the first form. Since the data on the first form has not been rendered
to the table (pencil picture in the record selector) and since the second
form is a continuation of the first form (same record) it doesn't work. How
should I render the record in the first form so that the second form knows
how to link? How should I go about fixing this issue? Please describe in
detail since I am new at this.

Thanks.
Iram/mcp
Click to expand...

Rather than using two forms, have you considered using a Tab Control?

On the other hand, if you have SO many fields that it takes two pages to
display them onscreen, your table is probably not properly normalized. A table
with over 30 fields is suspect (though I've been guilty of using tables with
as many as 60...)
 
How do I normalize?


Iram

John W. Vinson said:
Rather than using two forms, have you considered using a Tab Control?

On the other hand, if you have SO many fields that it takes two pages to
display them onscreen, your table is probably not properly normalized. A table
with over 30 fields is suspect (though I've been guilty of using tables with
as many as 60...)
Click to expand...
 
Iram said:
On a different form I have a macro on the "On click" of a checkbox that
opens
another form and closes a different form. I need to do the same thing as
far
as rendering however in a macro. How would you suggest that I do this in a
macro to render a record?

Iram/mcp
Click to expand...
<snip>

I don't do macros, sorry. Maybe someone else can take this one...
 
How do I normalize?
Click to expand...

It's a learned skill and to some extent an art; books have been written about
it. See

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

partiuclularly the "Database Design 101" chapter in Crystal's tutorial.
 
Thanks for your guys info on "Normalization" it is a new subjet that I will
have to study in the near future...

Going back to the Rendering a record like the "Me.Dirty" vba, the Save
function in the macro does not render like the "Me.Dirty" does...

Is there another way in Macros?...


Thanks.
Iram
 
Back
Top