Duplicate Record

O

Orlando

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
 
R

Rick Brandt

Orlando said:
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.
Click to expand...

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.
 
O

Orlando

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
 
O

Orlando

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
 
O

Ofer Cohen

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
 
Top