Various

[Steve]

Hi

Hope you can help as I am very new to this.

I have created a form that I would like to do the
following with:

1. I have changed "Allow Form Edits" to "No". I want to
add a button that edits the form (i.e switches back
again) but I need to stop people from scrolling down
through the records until the update button (set to No
again) is selected.

2. If I have a field indexed, can I have it so that when
I start typing in a field, it goes to the correct record
for that value. (i.e if i start typing "f" it goes to the
first lot of f's then "o" it goes straight to the fo's.

I know this maybe a little out of my league so early on
but needs must.

Many Thanks

Steve

 

[DanK]

Answer to Q#1:
There are several ways of dealing with this issue, here
are just two ideas.
1: Make all of the controls' enabled properties to NO and
then create a button that enables the controls you want be
able to edit (ie. Me![ControlName1].Enabled = -1. Me!
[ControlName2]. Enabled = -1...) Then... on the On Exit
property of each control, reset the Enabled roperty back
to 0. Then, have a button that refreshes the data (ie,
DoCmd.Refresh/Requery).

2: Make TWO subforms exactly the same, one with all
controls enabled, and the other with them all NOT
enabled. Place one subform exactly on top of the other
subflorm and make one of the SUBFORMS visible and the
other invisible. Place a button that toggles between the
two forms like this:
If Me![Form1].Visible = -1 Then Me![Form1].Visible = 0
Else Me![Form1].Visible = -1
(New Line)
If Me![Form2].Visible = 0 Then Me![Form2].Visible = -1
Else Me![Form2].Visible = 0
End Sub

 

[Guest]

Answer to Q2

Again, there are a couple of ways of doing this. Perhaps
the easiest is to create a combo box that queries on the
field you want. Combo boxes do exactly what you want,
when you type an r, it jumps to the first of the r
entries. Then the next letter further points to the
entered values. You need to make sure that the query is
sorted alphabetically!

 

[Steve]

Thanks very much

 

[Steve]

Thanks very much

 

[Steve]

Dank

Another question,

Will users still be able to page DN/UP if it is edit mode?

Thanks

Steve