Em Andamento

Search Feature on Access Form

I have a standard form called "Case Information" that displays data from a in text fields. I also included one extra field "Search Case Number" with a button to allow users to search the database and display that record on the "Case Information" form.

When the user clicks the search button, it runs the query "qrySearchCasesbyCaseNumber". If no record is found, it displays a MsgBox. If the record is found, I want it to display that record on the form. Right now it does nothing. Not sure if I need to use OpenForm, FindRecord, or what. Below is my code:

Private Sub Search_Case_Number_button_Click()

If DCount("[Case Number]", "qrySearchCasesbyCaseNumber") > 0 Then

'How do I display the record in the form here?

[url removed, login to view] "Case Information"

Else

MsgBox "The Case Number was not found."

End If

Exit_Client_Search_Click:

Exit Sub

End Sub

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

## Platform

Windows

Habilidades: Engenharia, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software

Ver mais: search display program, access form record, search extra fields, extra field search, search feature, use code access, php form search database, search feature php, text database access, search field extra, php text search, display extra fields, access search form query, access database search form, text access, code search data database, search data source php, access private, database search display, access database search query, private form, windows search, record access found, php search feature, php query form database

Acerca do Empregador:
( 123 comentários ) Lima, United States

ID do Projeto: #2983813

Premiar a:

Quadville

See private message.

$2 USD em 2 dias
(193 Avaliações)
5.5

12 freelancers estão ofertando em média $4 para este trabalho

Prashantskin

See private message.

$4.25 USD in 2 dias
(515 Comentários)
7.0
yenduttjain

See private message.

$4.25 USD in 2 dias
(117 Comentários)
6.7
danvlas

See private message.

$4.25 USD in 2 dias
(75 Comentários)
5.6
localprogrammer

See private message.

$3.4 USD in 2 dias
(19 Comentários)
3.5
johngalanopoulos

See private message.

$4.25 USD in 2 dias
(15 Comentários)
3.4
stolevw

See private message.

$3.4 USD in 2 dias
(28 Comentários)
2.6
ex3000

See private message.

$3.4 USD in 2 dias
(6 Comentários)
0.8
manwevw

See private message.

$3.4 USD in 2 dias
(1 Comentário)
0.5
eugenioesca

See private message.

$4.25 USD in 2 dias
(0 Comentários)
0.0
vw977112vw

See private message.

$4.25 USD in 2 dias
(0 Comentários)
0.0
janjuain79sl

See private message.

$4.25 USD in 2 dias
(0 Comentários)
0.0