hi,

too few parameters : does it also means that i have to have all the textfields on my form from the tables???

which means if i have 13 fields in my table, i will have to have 13 unbound textfield in my form???

is that so??? becoz the one that i am using is, there is actually more fields in my table as compared to my form???

coz i have checked every fields to see if it tallys or i have missed out anything but to no help, the error is still there. i really have no idea how to continue.

pls advice.
nono

The only controls you need on your form are fields you are assigning values to:

txtNRIC = rst!NRIC
txtName = rst!Name
txtAddress = rst!Address
txtContactNo = rst![Contact No]
txtDateOfNotice = rst!DateofNotice
txtStatus = rst!Status
txtReplyDate = rst![Reply Date]
txtAccountNo = rst![Account No]
txtAccountType = rst![Account Type]
txtSalary = rst!Salary
txtRemarks = rst!Remarks
txtMemo = rst!Memo
txtActionTaken = rst![Action Taken]

Copy the SQl below and paste it into your query designer SQL view and run it. Change the NRIC number to a valid NRIC number. Does it work? There is no point in embedding SQL in your code if you can't get it to run first as a standard Access query definition. Build your query in the query designer first, then paste the SQL into your module and format it as a string.

SELECT
    C.NRIC,
    C.Name,
    C.Address,
    C.[Contact No],
    C.DateOfNotice,
    C.Status,
    CA.[Account No],
    CA.Salary
FROM
    Customer_Account_Table As CA
INNER JOIN
    Customer_Table As C
ON
    CA.NRIC = C.NRIC
WHERE C.NRIC=1;

Don't add any more fields to your form until you can get something simple to run first. Then build.

Could it be that

strWhereClause = "[c.NRIC] = " & Me!txtNRIC
should be
strWhereClause = "c.NRIC = " & Me!txtNRIC



Sal

Hi Sal,

The brackets are basically ignored. It works either way.

Bob

Hi nono,

The other thing to bear in mind is that with the current setup using a single, columnar form, you'll only be able to see the last (highest, sorted by primary key) account number for each customer displayed in the form. I'm assuming you are using a 1-to-many relationship between the customers and customer accounts tables. If customers can have mutiple accounts, and you want to view all of them when you search for a customer, you'll need to introduce a 2nd form (subform) or listbox control to get the master/child view.

Viewing the last account may be fine for you, I don't know. On the other hand, you may want to consider other options if you are combining tables in a query.

Regards,

Bob

hi,

thanks for all the help given. i have solve the error.
the error is due to :

strWhereClause = "c.NRIC = " & Me!txtNRIC
should be in this format
strWhereClause = "c.NRIC = '" & Me!txtNRIC & "'"


cheers,
nono

Hi nono,

Remember my question 21 posts back when I asked:

"Which field is your search criteria ... and what's its data type?"

Well, I just got my answer.

Then 20 posts back I mentioned that I was using an integer...

If your NRIC field data type is an integer (number) you would use:

strWhereClause = "c.NRIC = " & Me!txtNRIC

If your NRIC data type is a string (text) you would use:

strWhereClause = "c.NRIC = '" & Me!txtNRIC & "'"

Glad its working for you. :)

Regards,

Bob

anyway really thanks!!!!!!
thanks for the help given so that i could work this out!!

cheerS!!!

No problem nono. I was just kiddin' around. Glad to help :)

Bob

Hi Nono,

I noticed a question in early on in this topic and wanted to point something out but never had the time. It's in regards to you set your controls to disabled and they we no longer as readable. If you also set you locked to Yes, it should display again as you originally set it.

HTH
-Roni

Roni Estein
Roni.Estein@e-drugscanada.com
https://www.e-drugsCanada.com