Search results

I would convert the Forms Macro to Visual Basic Then enter the following as the last line:- [Forms]![frmPayroll]![frmCDPayrollrecommSub].[Form].Requery

Sounds like you need to requery the Form

Hi June With my limited knowledge of VBA is the modified Module enclosed correct? Function ReturnData(lngMaritalStatus As Variant, dblBasicSalary As Variant, dblLower As Variant, dblExemptionCredit As Variant, dblAmountfromColumnA As Variant) As Double If Len("" & lngMaritalStatus) = 0 Or...

I get the same outcome as Gasman

Hi Alex Can you upload a copy of your current Excel file so we can see what your current requirements are?

Not having worked with Sharepoint I have no idea.

Hi Sorry to say but just fixing that 1 issue would not fix all of the problems in your database. You have spaces in names, you are using Lookup fields in tables as well as hard coded Lookup lists. Upload your fixed database and let us point you in the right direction.

Hi Your main problem is that your tblCandidates has a PK set as a Number Data Type when it should be an Autonumber. Your Main Form CandidateDetails is based on both the Candidates and Submissions table. The Main Form should be based only on tblCandidates. In your current Subform based on...

Hi Tested the file after downloading and it does not work. You need to recreate the Form as it must be corrupted.

Can you upload a zipped copy of he database?

Can you upload a copy of what you have created so far?

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.