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

[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

 

[Stuart McCall]

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

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.

 

[Iram]

Thanks. Your the man!


Iram/mcp

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.

 

[Iram]

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

 

[John W. Vinson]

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

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...)

 

[Iram]

How do I normalize?


Iram

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...)

 

[Gina Whipp]

Iram,

I posted links to normalization in one of your in the table design post.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Stuart McCall]

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

<snip>

I don't do macros, sorry. Maybe someone else can take this one...

 

[Gina Whipp]

Iram,

I don't do macros either, at least not in many years BUT if I remember
correctly there is a Save Record. Just open your macro and add it to the
end.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[John W. Vinson]

How do I normalize?

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.

 

[AccessVandal via AccessMonster.com]

John W. Vinson suggested a Tab control.

You can also use the Page Break control if it fits your requirement. You can
use the afterupdate event of the textbox or create a button to move to the
next page.

 

[Iram]

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

 

[AccessVandal via AccessMonster.com]

Sorry, not that I know of from Macros. The only way to read Dirty is from VBA
in the module of the form.