Duplicate Record

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

Guest

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
 
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.
 
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 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
 
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
 
Back
Top