I am a very new Access user. Just getting into it. I have created a database and want to do something that seems simple to me but I can't figure it out.

I have a database containing membership information for a local fishing club.

I want to be able to create a situation where I can do the following.

Enter a membership number and have the members info displayed so that I can then make any changes and update it. I want to be able to do this one member at a time so that I can update as changes come in.

Can anyone help.

Step 1) use the form Wizard to create your form.
Step 2) use the combo box wizard and check the 'find a record on my form based on the value I entered in to combo box'.

I will give it a try thanks

That seems to do it. Many thanks