Kamis, 07 Mei 2020

[MSAccessProfessionals] Form not working as expected

I am building a small database to capture basic customer information.  I created a table called tblcustinfo with the following fields:
custid (primary), custname, custaddr, custidnum.  I built a query on this table and then a form based on the query.  On the form I have a combobox for the name field so that I can select the customer name and the other fields are populated correctly.  So far so good!

Then all hell broke loose when there was a need for a date field to record the date the customer comes in.  This is where I am stuck.  I created another table called tbldaterec with the fields dateid (primary) and daterec.  I added a dateid field in tblcustinfo and did a joined the tables on this field.  Am I going correct?  I amended the query to include the new table and daterec field.  However when I included the daterec field on the form, my combobox no longer works. Got an error like joined field not in recordset.

What I am trying to accomplish is when I open the form I select the customer from the combobox and it automatically populates besides the name, the address and idnum (this was working fine until I added the date field).  The date field is not to be automatically populated.

Where am I going wrong?

Regards
Mercy
_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#115489) | Reply To Group | Reply To Sender | Mute This Topic | New Topic

Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Tidak ada komentar:

Posting Komentar