Edit a record on a form

[Kully121]

Hi,

How do i allow users to edit a record when a form is opened

Tried adding a record navigation/Find record button but it comes up with a error message

saying 'can't find or replace button now'

I have the form on Data Entry enabled

I guess i need to edit the code so it searches for customer number within the relevant table

Cheers,

Kully121

 

[SydneyGeek]

If you're trying to set up a search function, you have a few options.
1. Show your users how to select the field of interest and use Edit | Find to move to the record
2. ... Or right-click the field and Filter For...
3. Alternatively, you can have a combo box for searching. Once an item is selected from the combo, the form filters accordingly.
There may be others as well, depending on how sophisticated the search needs to be. Check out the Board for combo filter and see what you turn up.

Denis

 

[Kully121]

Can i use a code and assign it to a button without using a combo box?

 

[Norie]

Kuylly121

If you have DataEntry set to yes the only records the user could edit would be any new ones they added after opening the form.

To access any other records you need to turn Data Entry off.