Hello, .... and help please with forms and fields

[egg]

Hi All,

I'm new here as I have only just started to use access

I am just creating a very small and simple database (one table, five fields) for personal use.

My question is this:

I have a text field called [rank] which is a list of predefined texts eg "level1", "Level2" etc etc up to "Level9".

I have a form created to edit all the fields (which works fine) however I have created a button which I would like to do the following but don't know how to set it up .

When the button is pressed I want to automatically 'promote' the above field. ie if it is at "Level9" it changes it to "level8", or if its at "level2" it changes it to "level1" for all the different levels (if its at "level1" it shouldn't do anything)

Thanks in advance for your help

 

[egg]

Wow this must be really hard to do?? Anyone help at all??

 

[pbaldy]

Not particularly difficult. You want it to update the displayed record, or all records?

 

[pbaldy]

Well, here's a "displayed record" way:

  If Right(Me.Rank, 1) > 1 Then
    Me.Rank = "Level" & Right(Me.Rank, 1) - 1
  End If

 

[egg]

Thanks, yeah update just the displayed record.

I will try it as soon as i can

 

[egg]

Thanks Its all sorted !!!

Just gotta finish a few things and then look into security....