Updating a record

[Guest]

I have forms that are automatically produced with a click of a button -
reports setup to turn into PDF's. The report used is determined by the name
that is in a text field for that particular record. I have a pull down to
select from, I choose a name, then click my print button.

My question is when I click that name, since it is calling for data in a
field for that record, I have to go to another record first, so it gets
updated & recognizes the recent selection. I then can print the file.

Is there some kind of coding I can put in for the pull down so when I select
it, it like requires the db or something, so I can skip this annoying step?

Thanks
Curtis

 

[RuralGuy]

I have forms that are automatically produced with a click of a button -
reports setup to turn into PDF's. The report used is determined by the name
that is in a text field for that particular record. I have a pull down to
select from, I choose a name, then click my print button.

My question is when I click that name, since it is calling for data in a
field for that record, I have to go to another record first, so it gets
updated & recognizes the recent selection. I then can print the file.

Is there some kind of coding I can put in for the pull down so when I select
it, it like requires the db or something, so I can skip this annoying step?

Thanks
Curtis

Add:

If Me.Dirty Then Me.Dirty = False

to the beginning of the print button code.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[Guest]

If Me.Dirty Then Me.Dirty = False

to the beginning of the print button code.

Wooo hooo!

It seems like if I can dream it up, Access can do it!

What does the Dirty mean though?

 

[RuralGuy]

Wooo hooo!

It seems like if I can dream it up, Access can do it!

What does the Dirty mean though?

The Dirty Flag is set whenever *any* field has been changed and needs to be
written to disk. Me.Dirty = False updates the record on disk with the new data.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[Guest]

The Dirty Flag is set whenever *any* field has been changed and needs to be

written to disk. Me.Dirty = False updates the record on disk with the new data.

Odd name for something like that....

 

[RuralGuy]

Odd name for something like that....

I believe it is a carry over from virtual memory or a page file scheme. If the
block of memory is dirty (modified from the disk copy) then it must be flushed
to disk before that page of memory can be overwritten.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.