Duplicate Record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Orlando - 18 Mar 2007 15:45 GMT

Hi, I have a consult in a form, but went I open the form I have the first
register in display, I can move backward and forward, but if I try to use the
option I created to bring a specific record (Typing the ID and click on a
command Buttom) and show the description, basically when I type the ID I am
modifying the data base, this consult bring the record but after I get a
message that there is duplicated record.

I would like to have an empty screen when I open the form, not having the
first record on display but after I get a record typing the ID box and click
on the command buttom, I Would like to be able to move the records backward
and forward.

Thanks in advance

Reply to this Message

Ofer Cohen - 18 Mar 2007 15:52 GMT

You get this error message because the text box is bounded to the field in
the table, so you actually entering/changing the value in this field, and
that creating a duplicate

Check this link on "Searching for a record based on a text box value in a
form"

http://www.databasedev.co.uk/text_search.html

Signature

Good Luck
BS"D

> Hi, I have a consult in a form, but went I open the form I have the first
> register in display, I can move backward and forward, but if I try to use the
[quoted text clipped - 9 lines]
>
> Thanks in advance

Reply to this Message

Rick Brandt - 18 Mar 2007 16:00 GMT

> Hi, I have a consult in a form, but went I open the form I have the first
> register in display, I can move backward and forward, but if I try to use the
[quoted text clipped - 7 lines]
> on the command buttom, I Would like to be able to move the records backward
> and forward.

You cannot use the same TextBox for binding to your table-field and for doing
searches. Just add an unbound TextBox in the Header with a label like "Go
To..." and use that one in your button code.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

Orlando - 18 Mar 2007 20:56 GMT

Hi, I already did what you guys said, I created another text box and used the
code I found in the link that Ofer gave me in the command button and works
beautifully, now the problem is that I still can Modify the ID and
description field in the data base, how can I do to avoid that, I don’t want
the users modifying data in a consult.

Thanks

> > Hi, I have a consult in a form, but went I open the form I have the first
> > register in display, I can move backward and forward, but if I try to use the
[quoted text clipped - 11 lines]
> searches. Just add an unbound TextBox in the Header with a label like "Go
> To..." and use that one in your button code.

Reply to this Message

Ofer Cohen - 18 Mar 2007 23:35 GMT

Set the lock property of the text boxesto Yes

Signature

Good Luck
BS"D

> Hi, I already did what you gys said, I created another text box and used the
> code I found in the link that Ofer gave me in the command button and works
[quoted text clipped - 19 lines]
> > searches. Just add an unbound TextBox in the Header with a label like "Go
> > To..." and use that one in your button code.

Reply to this Message

Orlando - 19 Mar 2007 00:24 GMT

Hi again, I just placed the text box in the form header, but when I open the
form the cursor goes to the first text box in the detail section, How can I
do to force the cursor to go first to the text box I placed in the header

Thanks

> Set the lock property of the text boxesto Yes
>
[quoted text clipped - 21 lines]
> > > searches. Just add an unbound TextBox in the Header with a label like "Go
> > > To..." and use that one in your button code.

Reply to this Message

Ofer Cohen - 19 Mar 2007 00:36 GMT

You need to set the Tab order, place that field to be the first

To set the TabOrder, open the form in design view, from the menu select :
View > Tab Order

Drag the name of the text box in the header to be the first one

Signature

Good Luck
BS"D

> Hi again, I just placed the text box in the form header, but when I open the
> form the cursor goes to the first text box in the detail section, How can I
[quoted text clipped - 27 lines]
> > > > searches. Just add an unbound TextBox in the Header with a label like "Go
> > > > To..." and use that one in your button code.

Reply to this Message