access question

[amitbadgi]

Hi guys, I have created a form in access and want to display the result
in the same form, how do i do it?, coz once i enter the e=required and
click on search it goes to teh access table format where in it displays
teh result, now I want to display teh result in teh form wherein u
enter the required and click the search button, how do it?, thanx in
advance

 

[Guest]

If I understand it right you are going into datasheet view instead of form
view which you have created in access.

Go to Edit->select Form

Then
View -> properties

In the default view option change settings to single form instead of datasheet

Madhuri

 

[amitbadgi]

Hi Madhuri, I tried doing as u said and it was in the single form view
itself, i hope u got exactly what i am trying to explain, there is a
form in which u enter a businessid, and on clickign search the related
info is pulled from teh access database and displayed, noe when i click
search its going into teh datasheet view and displaying the results,
now i want to display teh result in the same form wherein the business
id is enetered. I have wriiten a query and attached it to a macro which
inturn i attached it to teh searchbutton(onclick). Thanks.