hello

B

BruceM

On the subform's property sheet, click the Format tab and set Navigation
Buttons to No.
 
V

vassilis

if u could help me in one more question pls...i made one form from a table,
including a combo box with an <after update-Find the record that matches the
control> function...but i noticed that while i scroll the mouse, the specific
combo box doesnot update its value as the other fields do...is there anything
that can be done?
thanks

Ο χÏήστης "BruceM" έγγÏαψε:
 
B

BruceM

If your combo box row source (I will call it cboComboBox) includes the
primary key field (I will call it RecordID), then in the form's Current
event put the code:

Me.cboComboBox = Me.RecordID

If RecordID is not part of the row source, you can add it. Change the combo
box column count to match the number of columns in the row source, and set
the column widths to 0 except for the column you want to see.
 
V

vassilis

<surname> is my combobox name and ID(autonum) one of my 2 keys included on
row source.
i wrote this on my Form <on current> event....

Private Sub Form_Current()
Me.surname = Me.ID
End Sub

and im taking : compile error, method or data member not found
and yellow collored the <Privet...> line.
what im doing wrong?
 
B

BruceM

You said that you have two key fields. Are they both named ID? Is the
column count correct? When you are in a code window and start typing, after
you type Me. you will probably see a list of choices. Is surname among
those choices? Is ID?
 
V

vassilis

After the second Me does not appear the ID field on the menu.....apears like
a/a that was the old name field but i change it because i thought the greek
fonts make me problems. i wrote it and then im taking that debug but i dont
understand why...
i have 2 keys but only one named ID..the combo box column count is at 2
column width at 0;2,54
 
B

BruceM

Is ID included in the form's record source?

vassilis said:
After the second Me does not appear the ID field on the menu.....apears
like
a/a that was the old name field but i change it because i thought the
greek
fonts make me problems. i wrote it and then im taking that debug but i
dont
understand why...
i have 2 keys but only one named ID..the combo box column count is at 2
column width at 0;2,54
Click to expand...
 
V

vassilis

i can see the ID field on the field list on desigh view but im not using it
in my form...
if there is nothing i can do ill make all the work from the start :)
 
B

BruceM

If you have been doing a lot of work on the database you should probably try
compacting it. Back it up, then click Tools > Compact and Repair. Close
it, then open it again.
If it still doesn't behave, I would try changing the name of ID (in table
design view) to something like NameID, then try to enter the code again.
 
B

BruceM

You're welcome. Sometimes a restart is all it takes. Even so, you should
try compacting the database as I suggested in the other message. Good luck
with the project.
 
Top