cycle records in a form

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

Hello, My question is in regards to cycling records
through a form. What I have is a form that has a combo box
(cmbSchool) that pushes value to a textbox (txtIP)I have
it designed for the purpose of looking up a schools IP
Address, but the problem I am having is that when the user
cycles through the record it adds another entry into my
table. All I would like to happen is for the user to enter
a schoolname into the combo box and have it populate the
txtIP box without adding a record. Your suggestions are
appreciated.
 
-----Original Message-----
Hello, My question is in regards to cycling records
through a form. What I have is a form that has a combo box
(cmbSchool) that pushes value to a textbox (txtIP)I have
it designed for the purpose of looking up a schools IP
Address, but the problem I am having is that when the user
cycles through the record it adds another entry into my
table. All I would like to happen is for the user to enter
a schoolname into the combo box and have it populate the
txtIP box without adding a record. Your suggestions are
appreciated.
.
Click to expand...
hi martin,
try view form properties, switch to the other tab. Change
Cycle from 'all records' to 'current record'

Luck
Jonathan
 
Back
Top