Combo box& Query (1 Viewer)

M

mohamedmatter

Registered User.

Local time

Yesterday, 16:02

Joined

Oct 25, 2015

Messages

112

• Mar 30, 2019

• #1

good day members
i attach database-
my problem in form
first i create combo box when l select THE id FROM COMBO BOX and run query not found record
second when i open form my combo box is not value i want when open form value equal the current id record in form
very thanks
members
what is error

 

Attachments

• EmployeeDB.accdb

  1,020 KB · Views: 38

June7

AWF VIP

Local time

Yesterday, 15:02

Joined

Mar 9, 2014

Messages

5,466

• Mar 30, 2019

• #2

Do not understand issue. I open form and combobox is blank, as it should be. I select a value in combobox and it finds correct record. Form works.

 

M

mohamedmatter

Registered User.

Local time

Yesterday, 16:02

Joined

Oct 25, 2015

Messages

112

• Mar 30, 2019

• #3

June7 said:

Do not understand issue. I open form and combobox is blank, as it should be. I select a value in combobox and it finds correct record. Form works.

Click to expand...

yes
problem in combo box and query EmployeeQry the query depend on combo box in form Employeefrm when i select id from combo box when run query not show the record

 

mike60smart

Registered User.

Local time

Today, 00:02

Joined

Aug 6, 2017

Messages

1,904

• Mar 30, 2019

• #4

Hi

Like June7 I am not following what is wrong.

The Form Works

Why do you need the EmployeeQry??

 

M

mohamedmatter

Registered User.

Local time

Yesterday, 16:02

Joined

Oct 25, 2015

Messages

112

• Mar 30, 2019

• #5

mike60smart said:

Hi

Like June7 I am not following what is wrong.

The Form Works

Why do you need the EmployeeQry??

Click to expand...

when i select id from combo box and run query not shown the record in form in query

 

Attachments

• 
  bandicam 2019-03-30 21-13-51-077.jpg

  96.6 KB · Views: 34
• 
  bandicam 2019-03-30 21-08-50-241.jpg

  95.1 KB · Views: 30

Last edited: Mar 30, 2019

June7

AWF VIP

Local time

Yesterday, 15:02

Joined

Mar 9, 2014

Messages

5,466

• Mar 30, 2019

• #6

Parameter is under wrong field. Should be ID1 because value of combobox is ID1.

 

mike60smart

Registered User.

Local time

Today, 00:02

Joined

Aug 6, 2017

Messages

1,904

• Mar 30, 2019

• #7

Hi

Again not following your process

You have a Form that allows you to select a specific Record to View.

Why do you then want to run the query??

 

M

mohamedmatter

Registered User.

Local time

Yesterday, 16:02

Joined

Oct 25, 2015

Messages

112

• Mar 31, 2019

• #8

June7 said:

Parameter is under wrong field. Should be ID1 because value of combobox is ID1.

Click to expand...

thanks that right

 

jdraw

Super Moderator

Staff member

Local time

Yesterday, 19:02

Joined

Jan 23, 2006

Messages

15,379

• Mar 31, 2019

• #9

@mohamedmatter

I noticed your Employeetbl has field Fullname with values Lastname Firstname. Your form has controls for Fullname, Firstname and Lastname, but Firstname and Lastname show ??. General approach is to use atomic fields --1 fact 1 field--(store firstname and lastname), then concatenate such fields if needed.
Good luck with your project.