Search results

It works just fine for me. In the attached I redid all of the Combobox's and everything works as it should

I replaced your Sex Combobox with a standard Combobox When you Tab into the Sex Control and type the first Letter of the required Sex it autopopulates. All very normal. Why go down the route of lots of VB ?

Hi Normally every table would have an Autonumber Primary Key. If you need to enter a Unique Patient Number, then this would be a field in your Patient Table. As for the search Code, which Combobox Control are you trying to search on ?

On your FNewPatient Form where is the Search Code located?

Why are your PK and all your related FK's set as text Data Types?

Can you upload the database so we can see the problem

Hi Can you upload a copy of your database with no confidential data?

Hi Same as Gasman - No Errors When I entered the data suggested it updates the Total Control and also goes to a new record in the subform.

Hi Alex Have you started putting together any tables in Access yet? If you have then upload a zipped copy and we can then advise much easier.

Hi You can use Word or Excel to indicate the structure you need.

How is everyone connected to the BE Hardwired LAN or WiFi?

If you select File - Account - About Access you will be able to see which Channel you are using It should be like the attached.

Hi It is best that you start a new thread rather than hijacking this thread.

Hi Your Relationships window should look something like the attached. This allows you to create a Main Form based on People with a Subform based on Levels and Ratings.

If you can see all the tables what do you want to do next?

When you start to add a new record in the subform you will automatically generate a new blank row. This is how a Continuous Form works.

Hi Well the Op said "I have a subform that I am entering records related to the ClientID on the main form."

You will always have a blank row in a Continuous subform

Can you upload a zipped copy of the database?

Hi In design view of the Form, if you Right Click on the Chart and select Properties you can remove the various Elements. See attached screenshot