Jumat, 08 Mei 2020

Re: [MSAccessProfessionals] Form not working as expected

Hello Mercy,

Why did you create the tbldaterec? Maybe I do not see the whole picture. You could have added the daterec filed to the table and made the field a date field and the user could choose from the dates or type it in. 

Jim Wagner


On Thursday, May 7, 2020, 09:06:36 PM MST, toukey1 via groups.io <toukey1=yahoo.com@groups.io> wrote:


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

Tidak ada komentar:

Posting Komentar