Blank Record Problem

[pgp]

Hi,

I have 2 main forms - create quote & revise quote form.

When I go to create quote form I have the quotenumber as an autonumber datatype.

So Using this form, I have a new autonumber generated everyti me I create a quote, with this, I enter all the other information on the form, and store it in a quoteheader file.

(Revisequoteform purpose - I enter the quotenumber & rev number, it gives me the corresponding details of the quote)

When I open the revisequote form, for some reason, a blank record with next quotenumber is automatically generated in the quoteheader file.This blank record does not allow me to update the quote that I had pulled up using revisequote form.

Everytime I try making some chnages to the quote using revise quote form, I have an error " changes requested cannot be made..." So I go back to my quoteheader table, delete the blank record, come back to revisequote form, it works smoothly!

I'm not able to understand how the blank record is automatically generated?

I would appreciate any suggestions/input
Thanks in advance

 

[Travis]

What runs when you revise a quote. Without knowing what Queries (and their syntax) or Code is running it makes it hard to say why are you getting a blank record.

Post the code behind the create revision (Button/Menu Option/or open event of a form).