Disabling new entry in recordset ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,
I have a form that populates data based on the data in a cboBox. That works
fine however as the user clicks through the 'next' button (custom buttons,
not the ones that come with the form) if the recordset returns say, two
entrys, if the suer clicks past the second record then tere is a thrid,
blank, new entry. Since the user will only be amending records that already
exist I don't want them to have the ability to add a new entry, so i'd like
to recordset to stop of the last record, not show a new record. How can this
be done ?

Thanks in advance,
Mitch....
 
Thanks John.
I did try that but then when I opened the form it was blank. none of the
controls were visible.
Is there another way ?
 
Thanks John.
I did try that but then when I opened the form it was blank. none of the
controls were visible.
Click to expand...

Usually this means that the Form's recordset is not updateable. What's
the Recordsource property of the form? If you don't set it, can you
edit data?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Thanks John.
I did try that but then when I opened the form it was blank. none of the
controls were visible.
Is there another way ?
Click to expand...

Normally this means that the Form's Recordsource is not updateable.
What *is* the recordsource? Can you edit data on the form if you don't
specify Allow Additions = False?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Hi John,
sorry for the delay in replying. As for the recordset behind the
form this is the SQL..

SELECT tblIssue.IDIss, tblIssue.Issue, tblSupport.Detail,
tblIssue.Resolution, tblIssue.upsize_ts
FROM tblIssue LEFT JOIN tblSupport ON tblIssue.IDIss = tblSupport.Issue
WHERE (((tblIssue.IDIss)=[forms]![frmAdmin]![cboissue].[value]))
ORDER BY tblIssue.Issue;

Does that help in any way ?

Thanks for your help in thbis,
Mitch....
 
Back
Top