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
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