Updating from Forms

A

ADMINISTRATOR

I have a form "FRM Tickets" which has four
controls "ID" "BKDATE" "CurrentDate" and "Fullname". I
have a command button on this form that first saves the
information and then opens up the "fRM Discounts".
On "FRM Discounts" I 20 different different
discounts "Discount1" thru "Discount20" and then it reads
from the FRM Tickets "ID" "BkDate" "CurrentDate"
and "FullName". The ID is a one to one relationship with
ID in my TBL Discounts, so I also have a control "TBL
Discounts!ID". I have my controls allowable for updating,
addition and deletions. However, when I go from my FRM
Tickets to my FRM Discounts, I cannot update any
information and if I don't already have a corresponding
TBL Discounts.id saved, I get a blank screen.

If I have a macro set to go to new record, it tells me I
can't go to specified record, that I may be at the end of
a record set.

What have I done to not allow a new record??
 
A

administrator

-----Original Message-----
I have a form "FRM Tickets" which has four
controls "ID" "BKDATE" "CurrentDate" and "Fullname". I
have a command button on this form that first saves the
information and then opens up the "fRM Discounts".
On "FRM Discounts" I 20 different different
discounts "Discount1" thru "Discount20" and then it reads
from the FRM Tickets "ID" "BkDate" "CurrentDate"
and "FullName". The ID is a one to one relationship with
ID in my TBL Discounts, so I also have a control "TBL
Discounts!ID". I have my controls allowable for updating,
addition and deletions. However, when I go from my FRM
Tickets to my FRM Discounts, I cannot update any
information and if I don't already have a corresponding
TBL Discounts.id saved, I get a blank screen.

If I have a macro set to go to new record, it tells me I
can't go to specified record, that I may be at the end of
a record set.

What have I done to not allow a new record??
.
PS ... The information is pulling directly from the
tables not from a query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top