end of recordset

A

administrator

I have two tables ... Tickets and Discounts, which have a
one to one relationship, with "ID" being the common
control.

I have two forms: FRM Tickets and FRM Discounts. On the
FRM Discount, I have controls reading FRM Tickets!ID from
the FRM Tickets screen. I need to open FRM Discounts from
FRM Tickets. I have a command on FRM Tickets that will
open FRM Discounts. When I try to jump to FRM Discounts
using the command button it's giving me a end of record
set and the form opens up but there is no fields. If I
open the form without using the command button, the form
will open up but will not let me enter any data.

So simply put, it's not letting me update, add, or edit
records in my FRM Discounts (the form is set to yes for
update, add or edit).

Any suggestions.
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Related Records 5
#Name? error in field values when subfrm linked to frm 0
Data entry 3
VBA works in orignal but fails in copy of database 1
Sort by date field 3
Allowing Duplicates Conditionally 3
End of RecordSet 1

Top